Michdd Posted December 5, 2008 Share Posted December 5, 2008 Currently I'm using this: SELECT *, (Wins / (Wins + Loses)) AS percentage from `table` where (Wins + Loses) > 0 AND (Wins + Loses) > 9 ORDER BY percentage DESC LIMIT 15 To get entries from the database that I can put into a board for the people with the highest Win %. However I want to adjust this so that if 2 entries output the same result, say if entries both have a 100% win average, it will put the one with the highest overall Wins + Loses before the other one with the same % wins. Quote Link to comment https://forums.phpfreaks.com/topic/135591-solved-ordering-by-2-seperate-things/ Share on other sites More sharing options...
fenway Posted December 5, 2008 Share Posted December 5, 2008 So use ORDER BY percentage DESC, (wins+losses) desc limit 1 Quote Link to comment https://forums.phpfreaks.com/topic/135591-solved-ordering-by-2-seperate-things/#findComment-706477 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.