dewey_witt Posted December 24, 2007 Share Posted December 24, 2007 Never had to do this till now so I hope im explaing myself right.... I would realy like to know the syntax for ordering mysql output by last record to first record. Any Clues? Quote Link to comment https://forums.phpfreaks.com/topic/82998-mysql-woes/ Share on other sites More sharing options...
dewey_witt Posted December 24, 2007 Author Share Posted December 24, 2007 NVM Found it.... Just neede to add ORDER BY id desc lol duh! stewpid me. Do i get a score for solving my own question? lol Quote Link to comment https://forums.phpfreaks.com/topic/82998-mysql-woes/#findComment-422147 Share on other sites More sharing options...
trq Posted December 24, 2007 Share Posted December 24, 2007 If the id field is auto incrementing it should not be relied upon for ordering. Place a timestamp field within your database and order by that instead. Quote Link to comment https://forums.phpfreaks.com/topic/82998-mysql-woes/#findComment-422149 Share on other sites More sharing options...
dewey_witt Posted December 24, 2007 Author Share Posted December 24, 2007 Ahhhhhhhhh...... thank you for the tip... Why is it that you cant rely on the auto_incremented field though? Just wondering..... Quote Link to comment https://forums.phpfreaks.com/topic/82998-mysql-woes/#findComment-422155 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.