help on a php 5 star rating system

[phpforfun]

Hey guys, sooo Im almost done with my site, all I need is to:
#1 finish the administrative side, (havent even started)
#2 finish the testimony/review, (the part where you rate the host)
#3 forums
#4 Random stuff (terms of service, about, support, help, etc)

So.. anywhere from a week to a month.


ALRIGHT!
Im extremely stuck on #2, I usually dont download and edit PHP scripts, just JS, but I had no idea where to start, other than maybe adding 1 to the number of times rated, then add the rating # to a field, so I could use some PHP math to get the average, and output that with a star image..

So I downloaded this script.
<see attached>

What im having an issue with is getting it to forget about the IP, forget about recording the raters data to a file, and make it use a MySQL database.

How can I make it so instead of adding data to a file with a bunch of BS, it just updates the rating field in the MySQL table

Thank you very much..

[John]

In the hosts profile, store the number of votes and the total value of the votes. When a vote is cast, update the hosts profile...It is trivial (unless I am missing something)

[phpforfun]

Thats what im trying to do, this code is just a lot different than I am used to. Im just having a hard time understanding it

[Jordan]

Write your own code. It is simple:

1) An HTML select form
2) Add a new row per vote with host id
3) Take the value of all votes and divide by the number of votes

You have the average vote number in a few PHP steps. It does seem trivial compared to what you have already written.....

[phpforfun]

it seems so, what you say requires a whole new table, that doesnt work so well for me :P

how about add the vote # to the total vote number (scale 1 to 5, user votes 4, adds 4 to the total)
meanwhile it adds 1 to the voted number, so it will divide voted_number by vote_number

[phpforfun]

Hum, it seems so, I guess looking at the other code just complicated it...

here is what I did.

Update Times Rated

PHP Code:

        $result = mysql_query("SELECT * FROM webmasters WHERE id='$hostid'");
        $get = mysql_fetch_array($result);
        $totalrates = $get['totalrates'];
        $newtotalrates = $totalrates + $rated;
        $query  = "UPDATE `webmasters` SET `totalrates`='$newtotalrates' WHERE `id`='$hostid'";
        mysql_query($query) or die('Error in query: '.$query.' :<br /><br /> '. mysql_error()); 


Echo The Stars

PHP Code:

$ratingpoints = $totalrates / $count;
if ($ratingpoints <= 0  ){$rater_stars = "./images/00star.gif";$rater_stars_txt="Not Rated";}
if ($ratingpoints >= 0.5){$rater_stars = "./images/05star.gif";$rater_stars_txt="0.5";}
if ($ratingpoints >= 1  ){$rater_stars = "./images/1star.gif";$rater_stars_txt="1";}
if ($ratingpoints >= 1.5){$rater_stars = "./images/15star.gif";$rater_stars_txt="1.5";}
if ($ratingpoints >= 2  ){$rater_stars = "./images/2star.gif";$rater_stars_txt="2";}
if ($ratingpoints >= 2.5){$rater_stars = "./images/25star.gif";$rater_stars_txt="2.5";}
if ($ratingpoints >= 3  ){$rater_stars = "./images/3star.gif";$rater_stars_txt="3";}
if ($ratingpoints >= 3.5){$rater_stars = "./images/35star.gif";$rater_stars_txt="3.5";}
if ($ratingpoints >= 4  ){$rater_stars = "./images/4star.gif";$rater_stars_txt="4";}
if ($ratingpoints >= 4.5){$rater_stars = "./images/45star.gif";$rater_stars_txt="4.5";}
if ($ratingpoints >= 5  ){$rater_stars = "./images/5star.gif";$rater_stars_txt="5";}
Echo '<img src="'.$rater_stars.'?x='.uniqid((double)microtime()*1000000,1).'" />'; ?> 


[Jordan]

Nice work!

[phpforfun]

Thanks, and $count is the number of testimonies left on the host, and each testimony has left $ rate, but the rate could be 1 through 5.