Help with ORDER a result

[alexguz79]

Hey everybody, i'm building a website for the softball league i play in.... so far the website is pretty good... with all the stats and profiles.... i'm having a little problem with the ORDER of the leaders in the categories i have to calculate the result...

 

for example... avg. is the result of the total hits divided by the total number of at bats... both numbers are coming from the database... the problem comes when i have to order the leaders from first to last...

 

this is my php:

 

$sql = "select profile_id, SUM(total_hits) AS hitstotal, SUM(ab) AS abtotal from batters WHERE year = '2010' GROUP BY profile_id"; 

$cons = mysql_query($sql); 
	while ($result = mysql_fetch_array($cons)) {
		$sumaab = $resultad['abtotal']; 
		$sumahits = $resultad['hitstotal']; 
		$p_id = $resultad['profile_id'];
		$prom = round(($sumahits."") / ($sumaab.""),3);

 

that gives me all the batting averages for the players.

 

and here is my question:

how can i order that $prom result from first to last?

[mentalist]

Get mysql to do it, then order with it...

 

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_avg

[alexguz79]

Thaks for the tip... but AVG won't fix the problem 'cause i need to order the RESULT of two different columns divided. That value is not in MySql.

[mentalist]

I remember running into this one,

http://dev.mysql.com/doc/refman/5.0/en/create-function.html

now my mysql is like kung fu (NOT!)