adding results of a query

[robsgaming]

i have a ratings script setup on my site for users to rate video games... here's the question..

i execute a query based on the field GAMEID in the ratings table... how can i add up all the results of a field and display them?

basically i have a result that looks like this:

Rating: 3 Game ID: 4500
Rating: 5 Game ID: 343
Rating: 1 Game ID: 453
Rating: 9 Game ID: 455

I want to add all the numbers returned for the RATING field.

thanks.

[planetsim]

well if your rating system is like this

id | gameid - or id of that game | rating | total votes

now set it up like that... or even set it up in the games table itself if it has 1..

rating will be added like if 5 voted for it will be rating = rating + 5 and total added by 1..

now when working it out

in the while loop

if($r[total] < 1)
{
$total_perc= 0;
}
else
{
$total_perc = round(($r[vote]/$r[total),2);
}

need more help pm with all code and table set out

[robsgaming]

thanks a ton! finally got it working with your help...

[planetsim]

np probs thats what were here for