Average-Ranking

[Remote4ever]

I am looking for an easy way to implement a rank voting. Users would rank 1-5 on a certain thing. I need that ranking to update the acuall average so that I can sort things by there average. How do I accomplish that\?

[cgraz]

use radio buttons that hold the value for 1-5. Now an average is total points over total number, so you'd need a field for points, and a field for submissions (be sure to set both fields to 0 initially).

Everytime someone submits

UPDATE table_name SET points = '$points', submissions='submissions + 1' WHERE id='$id'

assuming $points was your radio button that held the value 1-5. That would create a new total, and add one more to the total number of submissions.

Then, to calculate the average, query the database, put the points field in one variable, submissions in another, and divide them.

$average = ($points / $submissions);

That's how I'd do it off the top of my head.

Cgraz