[SOLVED] Displaying the sum of a query.

[pocobueno1388]

I have an image rating script where users can rate images between 1 and 5. The rating is added to the database and for each individual rating, there is an individual row for it...it doesn't like update a different field.

What I am trying to do is select the SUM of all the ratings added up that goes along with that piece of art. I have already read the mySQL manuel and I don't think my query is messed up...I think I am trying to print the number out wrong.

Code:
[code]
<?php

$get_rating = mysql_query("SELECT SUM(rating) AS rsum FROM gallerycomments WHERE artID='{$GET['artID']}'");
$imra = mysql_fetch_assoc($get_rating);

if ($imra['rsum'] == 0){
  echo 'No Rating';
} else {
  echo "{$imra['rsum']}";
}

?>
[/code]

Any help would be greatly appreciated xP Thanks.

[pocobueno1388]

Okay...I have been searching google and couldn't find much. What I did find was something about SUM not working in certain mySQL versions. I don't know if that is the version I have or not. Is there any other way I can accomplish getting the sum?

[marcus]

$_GET['artID']

[pocobueno1388]

-faints- Why do I do this to myself? Thank you so much for correcting my stupidity, hah. This is like the 2nd time in 3 days I have posted for help and it ended up being something so simple.

Thanks again xP