izbryte Posted January 9, 2008 Share Posted January 9, 2008 I have a script that selects the most recent inputted item for display: $query = "SELECT *FROM jobs DESC LIMIT 1"; Is there an easy way to select the 2nd most recent or 3rd? Link to comment https://forums.phpfreaks.com/topic/85106-solved-mysql-how-do-i-choose-the-2nd-most-recent-item/ Share on other sites More sharing options...
hitman6003 Posted January 9, 2008 Share Posted January 9, 2008 $query = "SELECT *FROM jobs DESC LIMIT 1, 1"; //selects the second item Link to comment https://forums.phpfreaks.com/topic/85106-solved-mysql-how-do-i-choose-the-2nd-most-recent-item/#findComment-434097 Share on other sites More sharing options...
izbryte Posted January 9, 2008 Author Share Posted January 9, 2008 k, gotcha! thanks! Link to comment https://forums.phpfreaks.com/topic/85106-solved-mysql-how-do-i-choose-the-2nd-most-recent-item/#findComment-434101 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.