this.user Posted May 15, 2010 Share Posted May 15, 2010 I have emails that are sent. All I want to do is view the last 100, how ever I want them to be ordered by date, with the oldest one at the top of the list. Could appreciate the help. Link to comment https://forums.phpfreaks.com/topic/201816-how-do-i-get-last-100-rows-without-using-order-by/ Share on other sites More sharing options...
trq Posted May 15, 2010 Share Posted May 15, 2010 SELECT email FROM emails ORDER BY datefield ASC LIMIT 100 Link to comment https://forums.phpfreaks.com/topic/201816-how-do-i-get-last-100-rows-without-using-order-by/#findComment-1058584 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.