RE: [PHP] mysql query for current id-1
| From: | Jason Dulberg | Date: | Tue, 02 Oct 2001 05:15:37 +0000 |
| Subject: | RE: [PHP] mysql query for current id-1 | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-69545@lists.php.net to get a copy of this message | ||
Awesome... Works perfectly!!
Thanks for your help!
__________________
Jason Dulberg
Extreme MTB
http://extreme.nas.net
> -----Original Message-----
> From: Maxim Maletsky (PHPBeginner.com)
> [mailto:php-general@phpbeginner.com]
> Sent: October 2, 2001 1:03 AM
> To: 'Jason Dulberg'; php-general@lists.php.net
> Subject: 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:jdulberg@nas.net]
> Sent: martedì 2 ottobre 2001 6.59
> To: Maxim Maletsky (PHPBeginner.com); php-general@lists.php.net
> Subject: 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)
> > [mailto:php-general@phpbeginner.com]
> > Sent: October 2, 2001 12:14 AM
> > To: 'Jason Dulberg'; php-general@lists.php.net
> > Subject: 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
> >
> >
> >