I want to create a poll which will ask users to rank a list of options from least favorite to most favorite. The results of the poll will tabulated based on which item has the highest score - ie: an item which receives 3 second favorite votes would rank higher than the item which receives a first choice, fourth choice, and fifth choice.
I want to be able to reuse the poll table each month with a different set of items.
I'm looking for advice on the best way to set up my Poll table. I'm inclined to have one row for each item with a total score and total votes column. But I could also see doing 1 row for each item of each vote (which would be maybe 10 rows per 'ballot') - but this would probably require a Poll table and a Poll-Votes table.
Two additional points:
1. I won't have a set number items for each month's poll.
2. I will not require users to vote for every item.
@Declan: I already have a very dynamic web site I've programmed in PHP and MySQL. Although I am not an expert, I understand both pretty well. I'm just asking for input on how to design the tables for my poll.
I want to be able to reuse the poll table each month with a different set of items.
I'm looking for advice on the best way to set up my Poll table. I'm inclined to have one row for each item with a total score and total votes column. But I could also see doing 1 row for each item of each vote (which would be maybe 10 rows per 'ballot') - but this would probably require a Poll table and a Poll-Votes table.
Two additional points:
1. I won't have a set number items for each month's poll.
2. I will not require users to vote for every item.
@Declan: I already have a very dynamic web site I've programmed in PHP and MySQL. Although I am not an expert, I understand both pretty well. I'm just asking for input on how to design the tables for my poll.