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 Quote 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 Quote 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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/7468-invert-results/#findComment-27209 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.