rating system.

[ohdang888]

Pretty simple question... i think...

 

 

I have a user voting system, they vote 1 through 5. Whatever they vote, that number is added to the score, and then adds 1 to the total votes.

Then to find the average, i would divide the score by votes. I want to display the top 10 highest average.

 

My table:

 

id--game--score--total votes

 

How would i do this?

I'm thinking its by an ORDER BY by i don't know how to do a "score/total votes" in the query.

 

 

the query for voting:

<?php
mysql_query("UPDATE `vote` SET `score` = (`score` + {$vote}) AND `votes`= (`votes` + 1) WHERE `game`='{$game}' ") or die(mysql_error());
?>

[ohdang888]

or would it be that i draw all the info, divide it, and sort it from there?

[ohdang888]

or use a cron job and add another column?

[Lamez]

I would use php to add and what not and set it to a variable, then use the variable to insert into the DB