Averaging out Ratings

[alexville]

Hey guys,

 

I want to make a rating system for my game site, and what I have in mind is using a php system where a user and submit a number from 1 to 10 and then it is inserted into a "ratings" table with a reference to the game's page id. But what do I do to show the average rating once the data is in the table?

 

Do I have to get all the ratings for a single game and average them out some how to get a rating? Can someone help?

[phpSensei]

Do you want to get the overall averaging rating, or just for a single page?

[alexville]

Do you want to get the overall averaging rating, or just for a single page?

 

I want to get the average rating for 1 game, not all of them.

[redarrow]

looks good...

 

<?php
$query = "SELECT field_name, AVG(field_name) FROM what_ever GROUP BY field_name"; 

$result = mysql_query($query) or die(mysql_error());
?>

[Brian W]

$user_rated/$rated_times = $value;
if(user_rated < $existing_rating){
$new_rating = $rating - $value;
} else {
$new_rating = $rating + $value;
}
//update db by changing rating and adding one to the rated_times field

[phpSensei]

Grab all the queries for the page id given (WHERE page_id = '$id'), then divide the ratings by the number of ratings to get the average

[redarrow]

this might work

 

This should do it i think....

<?php
$query = "SELECT AVG(number) FROM what_ever where id='$id'"; 
    
$result = mysql_query($query) or die(mysql_error());
?>