holowugz Posted March 10, 2006 Share Posted March 10, 2006 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 ? Quote Link to comment https://forums.phpfreaks.com/topic/4648-question-regarding-a-mysql-query/ Share on other sites More sharing options...
lessthanthree Posted March 10, 2006 Share Posted March 10, 2006 Pull the lastlogin value from the field before you update it with the new one (NOW()) that way youll get the previous login... Quote Link to comment https://forums.phpfreaks.com/topic/4648-question-regarding-a-mysql-query/#findComment-16261 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.