[SOLVED] getting average from query

[contra10]

i'm using this to get the average of a rating but it only calculates the lates input divided by the number of rows...

 

<?php

$query="SELECT * FROM `ratings` WHERE `ratedid`= '$id'";
$nt=mysql_query($query);
echo mysql_error();
$countofrate= mysql_num_rows($nt);
while($row=mysql_fetch_array($nt)){
  $rateresults = "{$row['rate']}";
}


$average = $rateresults / $countofrate;
print("Rated: $average");
?>

 

i don't know if COUNT is supposed to be used or if there is a way to add up all the rows...

[flyhoney]

SELECT AVG(rate) FROM ratings

[milesap]

	
<?php

$query="SELECT * FROM `ratings` WHERE `ratedid`= '$id'";
$nt=mysql_query($query);
echo mysql_error();
$countofrate= mysql_num_rows($nt);
$rateresults = 0;
while($row=mysql_fetch_array($nt)){
  $rateresults = $rateresults + $row['rate'];
}


$average = $rateresults / $countofrate;
print("Rated: $average");
?>

[printf]

Something like...

 

$query = "SELECT (SUM(rate)/COUNT(*)) AS average FROM ratings WHERE ratedid = '" . $id . "';";

 

 

[contra10]

thanks