I want to create a voting system so that the user rates the picture between 1 and 10...

Then it calculates an average from all the votes...

So it can display... 'Rating : average'

But then also list the top four rated pictures...
like..

Best Pictures
1. Imagename
2. Imagename
3. Imagename
4. Imagename

Anyone be able to help with the table structures and php??

Thanks

-James

James, what I would do is not to store off the value of every vote and then recompute the average every single time.

Create a table called ratings:

pictureId <-- primary key
total <-- the total of all votes cast (e.g., 7,7,10,1,6 = 31)
votesCast <-- exactly that -- in the example above, 5.


So as a new vote is cast, retrieve the record for the picture, increment votesCast by 1 and total by the value of the vote.

You may even want (for faster searching) to have a fourth column already computing the average. In fact, I would recommend that (let's call it averageVote) so that you could then perform your SQL pulls based on that value:

PHP Code:

$sql = "SELECT * FROM ratings ORDER BY averageVote DESC" 


Thanks

How would I divide the total by the votescast?

-James

$total / $votescast?

You've been here long enough to know how to grab info from the database

Thanks

Thought it would be something like that... Just making sure

I always think of the hard way of doing stuff..good job theres people to help

-James