i have build a marketing survey page where it will answer a few questions. My problem is how am i going to build it.For example, i have 3 questions each with a few choices(radio buttons).
Question1 : How do you find the product?
        a. like it very much
        b. like it
        c. does not like it
        d. does not like it at all
Question2 : Will you buy the product?
        a. definitely will buy
        b. may be will buy
        c. may be not buy
        d. definitely will not buy
Question3 : How do you find the quality of the product?
        a. very good
        b. good
        c. bad
        d. very bad
Say, about 100 people answer the questions and my problem is how am i going to store it in the database so that i can retrieve it later? when retrieving data, i would like to know how many people answer the questions, how many people choose answer a,b,c and d respectively for each questions. How my mysql table should be?

One way is to create a table to store all the form answers, plus one column (optionally) to store the user ID of the person who submitted the form.

The data types of each column should be an enumerated type for all radio button inputs. The possible values for these types would match the possible answers for the question.


Take care,

Nik
http://www.bigaction.org/