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"... Link to comment https://forums.phpfreaks.com/topic/135207-select-difference-between-2-fields-from-mysql/ 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) Link to comment https://forums.phpfreaks.com/topic/135207-select-difference-between-2-fields-from-mysql/#findComment-704225 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.