seany123 Posted September 15, 2011 Share Posted September 15, 2011 Currently i have a query which at the end has this order by (value/counter) desc"); which works fine, however i was wondering, if in the case that 2 rows have the same, is it possible to set a second value to order by? Quote Link to comment https://forums.phpfreaks.com/topic/247198-how-to-set-a-second-order-by-value/ Share on other sites More sharing options...
Adam Posted September 15, 2011 Share Posted September 15, 2011 Yup: ORDER BY x ASC, y DESC Quote Link to comment https://forums.phpfreaks.com/topic/247198-how-to-set-a-second-order-by-value/#findComment-1269586 Share on other sites More sharing options...
seany123 Posted September 15, 2011 Author Share Posted September 15, 2011 Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/247198-how-to-set-a-second-order-by-value/#findComment-1269587 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.