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? 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 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. 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..... Link to comment https://forums.phpfreaks.com/topic/82998-mysql-woes/#findComment-422155 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.