Picture / story comparison script

[mac1979]

Hello,

I am trying to implement a story/ picture voting script.

I have started with using php and mysql.

The functionality is as follows:

1)user uploads a photo of a landscape or nature.
2)user writes a short story about where and how they took the photo.
3) photo is featured on the landing page of the website.
4) other users vote for that photo/ story.

I was going to implement it by using a mysql database and using one of the fields as a voting tally.

Where i am struggling is the vote comparison script to define a winner. I am even questioning if php/ mysql is the best method.

Any help would be greatly appreciated with this. Thank you.

[Derokorian]

If users log in, I would make a vote table which stores their user_id and what they vote for so that a user can't vote 2, 3 or even 5000 times. Then to retrieve them I would use count() and a join like this (roughly):

SELECT 
   (SELECT COUNT(*) FROM votes v WHERE v.item_id = i.id) as votes,
   i.title, i.image, i.story
FROM items i