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] > 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:[EMAIL PROTECTED]] > Sent: marted́ 2 ottobre 2001 6.59 > To: Maxim Maletsky (PHPBeginner.com); [EMAIL PROTECTED] > 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:[EMAIL PROTECTED]] > > Sent: October 2, 2001 12:14 AM > > To: 'Jason Dulberg'; [EMAIL PROTECTED] > > 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 > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
