Just have one row per choice. So table would have rows such as (example id)
Seq, person ID, Poll id, choice id, response. Where seq is a unique identifier, Person is some identifier of the person taking the poll. Poll ID is the id of the poll being taken ( a person can off course take more than one poll. Choice id is the identifier of the choice for this specific poll (1 or more per poll). Response of this question. Pat From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Tedit kap Sent: Monday, July 14, 2008 11:28 AM To: [email protected] Subject: [php_mysql] table for poll Hi I will create a table for the poll script I am going to do. Obviously my polls will have different number of choices, some will have 2, some will have as many as may be 15 or so... How can I create a table for that? Shoudl I just create a table for a lot of choices to cover everything - say 20 would cover me forever for the worst case...But if I create a table with 20 columns, then would it occupy a lot of memory, or as long as those cells are empty, it really doesnt matter as far as memory and speed efficiency? Any other suggestions about how to plan this? Thanks [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
