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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.