RE: [PHP] mysql query for current id-1

What about this: $sql="select id,agent,host, DATE_FORMAT(time_in, '%M %d, %Y, %l:%i') AS unixdate from logged_in WHERE userid='$current_user' ORDER BY id DESC LIMIT 1"; I think this should work for your case. Maxim Maletsky www.PHPBeginner.com -Original Message- From: Jason Dulber

RE: [PHP] Namo Web Editor

>From http://www.namo.com/products/we4/info/features/we4_sitewiz.html "Do you still think you have to learn about HTML tags, JavaScript, and Photoshop? Do you still think you have to buy all those expensive and hard-to-learn programs? Namo WebEditor 4 comes with Site Wizard that helps you create

[PHP] Ê®ÔÂÆóÒµ½¨Õ¾´óÀñ°ü£¬²»¿É´í¹ýŶ!

Ì컥¿Æ¼¼Â¡ÖØÍƳöÊ®ÔÂÆóÒµ½¨Õ¾´óÓÅ»ÝÌײͣ¬¼Û¸ñ¿Õǰʵ»Ý£¬ÈÃÄúÇáËɽøÈëÍøÂçÉÌÎñÁìÓò¡£Á¼»ú²»¿É´í¹ý! ¡î»ù±¾´óÀñ°ü£¬Á¢¼´½ÚÊ¡60Ôª! »ù±¾ÐÍ¿Õ¼ä+¹ú¼ÊÓòÃû 350Ôª/Äê ×î¾­¼ÃµÄÆóÒµ½¨Õ¾·½°¸! ÈÎÑ¡¹ú¼ÊÓòÃû£¬ÈÎÑ¡Ò»ÖÖ»ù±¾ÐÍ¿Õ¼ä(ASP¡¢PHP¡¢JSP) ËÍ5¸öPOPÆóÒµÓÊÏä¡£ ¡îÔöÇ¿´óÀñ°ü£¬Á¢¼´½ÚÊ¡100Ôª! ʵÓÃÐÍÆóÒµ½¨Õ¾·½°¸

Re: [PHP] mysql query for current id-1

Hi, The reason probably is that you're limiting from the 2nd row, instead of the first, 0 is the row starting point (I think). So : $sql="select id,agent,host, DATE_FORMAT(time_in, '%M %d, %Y, %l:%i') AS unixdate from logged_in WHERE userid='$current_user' ORDER BY id DESC LIMIT 0, 1"; = *

Re: [PHP] Newbie But Urgent

Hi, Well take a look at a library I've implemented in PHP : http://www.paphe.com/php/scripts/authlib.html P.S - PHP is way faster, and ofcourse much more elegant than ASP, however it's a matter of personal preference. = * Know more about me: http://www.geoci

Re: [PHP] sessions in php4

Hi, Well probably because you've got that automatic PHPSESSID thing carryover in your php.ini which through your situation indicates that it doesn't work in a header() so either you'll put cookies on, or use PHPSESSID. = * Know more about me: http://www.geocit

RE: [PHP] mysql query for current id-1

Thank you for your lightning fast response!! I tried your query but it appears to be coming up with the current id rather than the users last login. __ Jason Dulberg Extreme MTB http://extreme.nas.net > -Original Message- > From: Maxim Maletsky (PHPBeginner.com) > [mai

RE: [PHP] mysql query for current id-1

... DESC LIMIT 1,1 As you wrote yourself. Sorry, haven't taken in consideration ;-) Maxim Maletsky www.PHPBeginner.com -Original Message- From: Jason Dulberg [mailto:[EMAIL PROTECTED]] Sent: martedì 2 ottobre 2001 6.59 To: Maxim Maletsky (PHPBeginner.com); [EMAIL PROTECTED] Subjec

RE: [PHP] mysql query for current id-1

Awesome... Works perfectly!! Thanks for your help! __ Jason Dulberg Extreme MTB http://extreme.nas.net > -Original Message- > From: Maxim Maletsky (PHPBeginner.com) > [mailto:[EMAIL PROTECTED]] > Sent: October 2, 2001 1:03 AM > To: 'Jason Dulberg'; [EMAIL PROTECTED] > Su

Re: [PHP] sessions in php4

I always using session together with header() and never got a problem. Here's something might be a hint to you: http://..."; // in the "new location" ?> Alex - Original Message - From: "sagar N Chand" <[EMAIL PROTECTED]> To: "php" <[EMAIL PROTECTED]> Sent: Monday, October 01, 2001 9:5

RE: [PHP] MySQL Ability

Yes Devin, mySQL is fast enough, but it is not *really* a database. There are many reasons why some say mySQL is rather close to a file system with SQL interface than to a DBMS. If you really care about how robust and efficient your database is then you should look into PostgreSQL which by many

[PHP] Re: Warning: Sybase message: Incorrect syntax near 't'.

Caleb Carvalho wrote: > $sybase_query="INSERT into problem > VALUES('$product','$pro_title','$description','$solution')"; > $sybase_result=sybase_query($sybase_query); > Hi try this : $sybase_query=quoted_printable_decode("INSERT into problem VALUES('$product','$pro_title','$description'

[PHP] W3C and Open Source battles

Hallo all, might be a bit OT but nevertheless quite important. See http://lwn.net/daily/#t33 -- Wolfgang Ebneter M.Sc. Data Engineering Medienzentrum Osnabrück [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands

[PHP] Upload problem

Dear PHPmania, I am new to PHP and I start to write some script. $folder = USER_ENV(ID_user); // echo $folder; $destination = "/home/gilijk/data/".$folder; // echo $destination; if ($filename1!="none") { copy($filename1,$destination."/".$filename1_name); echo "$filename1_name telah

[PHP] Re: Array Elements & While Loops

Hi. Don't forget to increment j : > //loop to check for bad email addresses: > $j = 0; > $flag = 0; > while ($j < count($User)){ > if > (($User[$j]!="")&&!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*$", > $User[$j])) > { > $flag = 1; > $errorNo = $j + 1; > } >$j

[PHP] named anchors and query strings

Hi Guys, How do you reference both a named anchor and a query string in a link? i.e. link text I am not sure if this is even possible? thanks Scott -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [PHP] Warning: Sybase message: Incorrect syntax near 't'.

Hi, I suggest to you: var_dump($sybase_query); It may help you to make wellformed query-string. - Original Message - From: Caleb Carvalho <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 01, 2001 11:04 AM Subject: [PHP] Warning: Sybase message: Incorrect syntax near

<    1   2