I'm building on online survey with multiple choice questions for a client.
Client will be able to add/edit surveys, add/edit questions, and get
stats once folks have taken the survey.
I'm puzzling a little over the best way to collect answers.
Tables are sorta like
1. SurveyMaster
a. surveyID
b. surveyTITLE
2. SurveyQuestions
a. surveyID
b. questionID
c. question
d through g - selectable answers
There's not a set number of questions for any survey. The client could
enter 2 questions, or 50 questions, who knows (always four possible
answers though) - so I thinking that perhaps in the answer table every
single questions gets a row to itself?
3. SurveyAnswers
a. surveyID
b. questionID
c. questionANSWER
This might make it easier to calculat stats.
Or, would it be better to build an array like
questionID|questionANSWER and store all the answers from one user that
way. Will take a little more head scratching to quild stats from this
though (so it seems)
How would any of you do it? Seems to be any number of ways. What might
be the most optimal?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234207
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
