Re: AVG Displays Null

[Liam]

Thanks.

I've tried that, and it prints fine as SQL (As I can see my using phpmyadmin). However, when I go to echo it it still orders it by default (art_ID). Here is my code:

<?php
$i=1;
$ii=1;
$select = "select art_ID, art_Name, art_Url, art_Price, FORMAT(AVG(vot_Score), 2), artvot_ID from art, voting where artvot_ID = art_ID group by art_ID order by 'FORMAT( AVG( vot_Score ) , 2 )' DESC;";
$result = mysql_query($select, $ServerConnect);
while($r=mysql_fetch_array($result) and($i<11)){
$score=$r["FORMAT(AVG(vot_Score), 2)"];
$name=$r["art_Name"];
$id=$r["art_ID"];
$price=$r["art_Price"];
echo "$ii. <a href =\"art.php?id=$id\">$name</a> - £$price.00 - $score<br>";
$i=$i+1;
$ii=$ii+1;}
?>

Basically it should collect the first 10 results (which it does fine), and order it by rating (top first - which it doesn't!)

Thanks again.