ohdang888 Posted March 22, 2008 Share Posted March 22, 2008 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()); ?> Quote Link to comment https://forums.phpfreaks.com/topic/97410-rating-system/ Share on other sites More sharing options...
ohdang888 Posted March 22, 2008 Author Share Posted March 22, 2008 or would it be that i draw all the info, divide it, and sort it from there? Quote Link to comment https://forums.phpfreaks.com/topic/97410-rating-system/#findComment-498452 Share on other sites More sharing options...
ohdang888 Posted March 22, 2008 Author Share Posted March 22, 2008 or use a cron job and add another column? Quote Link to comment https://forums.phpfreaks.com/topic/97410-rating-system/#findComment-498491 Share on other sites More sharing options...
Lamez Posted March 22, 2008 Share Posted March 22, 2008 I would use php to add and what not and set it to a variable, then use the variable to insert into the DB Quote Link to comment https://forums.phpfreaks.com/topic/97410-rating-system/#findComment-498497 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.