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. 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 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
Archived
This topic is now archived and is closed to further replies.