adam_gardner Posted April 15, 2006 Share Posted April 15, 2006 hi guys,sure this is real simple for the pro's i just don't know the operator or whatever to make it work.my msgID field is unique, so - SELECT * from messages ORDER by msgIDworks finebut how would i invert the order (so msgID 3 showed above 2 etc.)thanks for the help!Adam Link to comment https://forums.phpfreaks.com/topic/7468-invert-results/ Share on other sites More sharing options...
Barand Posted April 15, 2006 Share Posted April 15, 2006 SELECT * from messages ORDER by msgID DESC Link to comment https://forums.phpfreaks.com/topic/7468-invert-results/#findComment-27200 Share on other sites More sharing options...
redarrow Posted April 15, 2006 Share Posted April 15, 2006 [!--quoteo(post=365024:date=Apr 15 2006, 09:27 AM:name=adam_gardner)--][div class=\'quotetop\']QUOTE(adam_gardner @ Apr 15 2006, 09:27 AM) [snapback]365024[/snapback][/div][div class=\'quotemain\'][!--quotec--]hi guys,sure this is real simple for the pro's i just don't know the operator or whatever to make it work.my msgID field is unique, so - SELECT * from messages ORDER by msgIDworks finebut how would i invert the order (so msgID 3 showed above 2 etc.)thanks for the help!Adam[/quote]lookup rsort Link to comment https://forums.phpfreaks.com/topic/7468-invert-results/#findComment-27201 Share on other sites More sharing options...
adam_gardner Posted April 15, 2006 Author Share Posted April 15, 2006 damn, i knew it would be so simple!thanks!adam Link to comment https://forums.phpfreaks.com/topic/7468-invert-results/#findComment-27209 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.