$data = "select avg(votes) from voting order by avg(votes) DESC limit 10"; $result = mysql_query($data) or die (mysql_error()); while($ratings = mysql_fetch_array($result)) { $rateavg=$ratings['avg(votes)']; echo "&israte=".round($rateavg,2); }