[SOLVED] Subtract in ORDER BY

[dreamwest]

I need to divide one column with another and sort a value of 5 DESC

 

Original code:

 
$sql = "SELECT * FROM rank ORDER BY total_value DESC ";

 

Now i need to divide 2 columns - total_value and total_count, then ORDER by 5 DESC

 

What ive come up with so far:

$sql = "SELECT * FROM rank ORDER BY (total_value/total_count) DESC ";

 

(total_value/total_count)  will always produce 5 or less

[fenway]

So, what's wrong with that?

[dreamwest]

Your right it works.

 

Didn't think you could divide to columns values against each other within a query