Re: mysql query for current id-1
| From: | Mukul Sabharwal | Date: | Tue, 02 Oct 2001 04:26:29 +0000 |
| Subject: | Re: mysql query for current id-1 | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-69540@lists.php.net to get a copy of this message | ||
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";
=====
*********************************
Know more about me:
http://www.geocities.com/mimodit
*********************************
__________________________________________________
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com