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 ? 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... 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
Archived
This topic is now archived and is closed to further replies.