[SOLVED] 5 star rating system

[play_]

It's not code i need help with, but on the math behind it.

 

Say i have a 5 star rating system for blog entries.

 

I would store in the database..

 

table: ratings

 

ratingID    |    userID    |    entryID    |    rating   |
------------+--------------+------------+----------------+
      1     |      43      |      3     |      5         |

 

Something like that.

 

Now from here i'm suck.

 

Say i go to a blog entry's page...how will i know how many stars to "light up" based on the database info?

is it based on the average?

[dadamssg]

yes

[play_]

but once i find the average, how do i know how many stars to light up based on it?

[Garethp]

Well, if the average is three, light up three stars. If the average is four, light up four stars

[play_]

Alright thanks.

 

i guess something like this will suffice

 

<?php

$ratings = array( 1, 4, 3, 2, 2, 1, 5, 3 ,4 ,4 ,4 ,3 ,5, 2, 3, 1, 5, 5, 5 ,5 ,5 ,5 ,5 ,5 ,5);

$sum =  array_sum($ratings);

$count = count($ratings);


echo $sum / $count;
?>