I am working on a site that is going to have hundreds of polls that people can vote on. Once any user creates a new poll (vote: Hayden Panettiere vs. Kristen Bell as an example) I want to have the database remember what member voted on what, for each poll. So user 1 voted Hayden, user 327 voted Kristen.. etc.. I expect up to 500 users to vote on each topic, but a new column to store each username that voted seems insane. I was thinking arrays, but am not sure if that would work. I don't think that a new table per poll would be very efficient either, it would be like 500++ tables on one database.
To explain better, my username is Paradox and I vote for Kristen Bell. When I look at this database I want to see:
ID Title Option1 Option2 People who voted option 1(27 people) People who voted option 2(783 people)
1 Heroes 27 783 {Blah, Blah, Blah} {Paradox, Blah, Blah}
Is an array a good way to go about this? Because I also want to be able to expand the array to notify each member they voted with the winning or losing team once the poll expires.