chriscloyd Posted April 17, 2007 Share Posted April 17, 2007 I have a table called teams i need to order them with wins/losses/ties so i have 12 teams Rank Team Name Wins Losses Ties 1 Team 1 8 0 0 2 Team 2 7 0 1 3 Team 3 7 1 0 4 Team 4 6 2 0 Can someone help me figure this out. Can you do mutli ORDER when doing a mysql_query? Link to comment https://forums.phpfreaks.com/topic/47403-order-with-php/ Share on other sites More sharing options...
otuatail Posted April 17, 2007 Share Posted April 17, 2007 ORDER BY wins , Losses DESC, Ties ASC This will order using the fields in the order you specify and in the ASC or DESC you supply. Desmond. Link to comment https://forums.phpfreaks.com/topic/47403-order-with-php/#findComment-231300 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.