I have aquired a very large job where I need to have users vote on hundreds of items. I am having trouble figuring out how to plan out the database....
i was thinking of having a table with all the items but then how would i store there vote values? Users can only vote once and I am just lost on how I should plan this db out. Any help would be great...
details
-items total over 400
-voting will be an in between 1-10 and averaged with total votes
-users will be stored in a different table
-all on mysql
im not asking for code just a way (plan) on how to store all the data
-mod_frank
