Linking MySQL Database Info to Pages

[rsnider19]

Without giving too much of my site idea away, I want to make a site where users can cast a vote on something and also see others votes as well. Say I have 2 pages, apples and oranges, and you can vote like or dislike on either of them. So you go to the apples page and see 12 people voted like and 5 people voted dislike. Then you can vote. Likewise you can go to the oranges page and see 8 people voted like for oranges and 2 people voted dislike.

[WingedPanther]

This is fairly simple, but can be implemented a few different ways. Is your question about how to store the data in the database, how to present it, how to read from the database, or something else?

[rsnider19]

I figure I will be able to set up the "poll" easily, so I would say it is more of a matter of displaying each page's results prior to the voting.

[WingedPanther]

You will need to start with a simple decision: are you going to store each user's vote per item, or just the aggregate for each item?

[rsnider19]

Just the aggregate and to be able to display x amount of votes per choice and % of votes per choice.

[WingedPanther]

I'm not clear on what the question is. You need a simple database to store the data, and a little SQL to get the data out of it. Is it an HTML question, a PHP/ASP/other question, something else?

[rsnider19]

Well I'm not sure if it is an html question or scripting question. I guess this might help show what I mean:

www(dot)ratemyprofessors(dot)com/ShowRatings.jsp?tid=335188

See how there are 17 ratings in all of those categories and then a user can look and see them and then, if her/she wants, can vote as well. I want to be able to do something like not, but it doesn't involve teacher ratings.