[Resolved] Calculating averages for rating script

[VooDooRT]

I looked through all the forums for something to use, but nothing wants to work right:

$query = "SELECT AVE(rated_number) AS average FROM gallery_ratings WHERE image = '$id'";
$ratingx = number_format($query['average'], 1, '.', '');

I want to echo out the average number just as a number. It keeps echoing out 0.0 though, even if there are ratings in the database.

[pjleonhardt]

Originally posted by VooDooRT
I looked through all the forums for something to use, but nothing wants to work right:

$query = "SELECT AVE(rated_number) AS average FROM gallery_ratings WHERE image = '$id'";
$ratingx = number_format($query['average'], 1, '.', '');

I want to echo out the average number just as a number. It keeps echoing out 0.0 though, even if there are ratings in the database. [/B]

try...

$query = "SELECT AVE(rated_number) AS average FROM gallery_ratings WHERE image = '$id'";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$ratingx = number_format($row['average'], 1, '.', '');

you wrote out the query string, but you never actually queried your database, then you have to fetch the resulting array..
The example above assumes mySQL

[VooDooRT]

Darnit. I knew it was going to be something silly. Thanks!