JSHINER Posted August 20, 2007 Share Posted August 20, 2007 Currently I have "ORDER BY name ASC" - can I add a second ORDER BY in there? I tried "ORDER BY package DESC AND name ASC" but it did not work. Quote Link to comment https://forums.phpfreaks.com/topic/65857-solved-order-by-question/ Share on other sites More sharing options...
marcus Posted August 20, 2007 Share Posted August 20, 2007 ORDER BY row1,row2 ASC Quote Link to comment https://forums.phpfreaks.com/topic/65857-solved-order-by-question/#findComment-329127 Share on other sites More sharing options...
akitchin Posted August 20, 2007 Share Posted August 20, 2007 don't forget that you can also specify individual orders for each clause: ORDER BY row1 ASC, row2 DESC Quote Link to comment https://forums.phpfreaks.com/topic/65857-solved-order-by-question/#findComment-329128 Share on other sites More sharing options...
JSHINER Posted August 20, 2007 Author Share Posted August 20, 2007 Worked perfect. Thank you! Quote Link to comment https://forums.phpfreaks.com/topic/65857-solved-order-by-question/#findComment-329131 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.