mikefrederick Posted December 2, 2008 Share Posted December 2, 2008 I have two fields, wins and losses, in my table. I want to order the results by wins - losses. Is there anyway to do this from within the mysql_query? Calculating the difference between the two fields would be easy afterwards with php, but since I want to order the results by the difference I am looking to do something like "select whatever as"... Quote Link to comment Share on other sites More sharing options...
haddydaddy Posted December 2, 2008 Share Posted December 2, 2008 Pretty simple, you can order by the absolute value of two numbers... example: SELECT * FROM table WHERE abc = value // optional ORDER BY ABS (wins - losses) 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.