Jump to content


Photo

Question regarding a MYSQL query


  • Please log in to reply
1 reply to this topic

#1 holowugz

holowugz
  • Members
  • PipPipPip
  • Advanced Member
  • 46 posts

Posted 10 March 2006 - 11:01 PM

I an app i am creating i have to store the login's people make, and on the main page i want to display the last time that person logged in.

Now if i just done a query it would pull the most recent login but i want the one before that, how can i specify in the query to get the row before ?



#2 lessthanthree

lessthanthree
  • Members
  • PipPipPip
  • Advanced Member
  • 85 posts
  • LocationUK

Posted 10 March 2006 - 11:06 PM

Pull the lastlogin value from the field before you update it with the new one (NOW()) that way youll get the previous login...
call me a safe bet, i'm betting i'm not




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users