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? Quote Link to comment 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. Quote Link to comment 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.