Hi im hoping someone here can give me a little advice / guidance
Basically im devising an online questionnaire/poll building system. Now what i would like to do is once a questionnaire is completely build i would like to set the questionnaire for specific users to complete.
As each user completes the questionnaire i would like them to store the results in the MySQL DB.
At the moment i have two tables for the polling / questionnaire element of the system.
tbl_questions consists of :
qid - Questionnaire ID Number
qnumber_1
qnumber_2
qnumber_3... through to
qnumber_25
qdesc - Questionnaire Description
rid - Links to Response ID in the responses table
tbl_responses
rid
response_desc - Response Description
response_1
response_2... through to
response_10
Now im assuming i would need to create another table , would i need grab both the Response ID and the Questionnaire ID and then store results?
Or would it work differently .
In the end i would basically like the administratiors be able to take the results from the questions
So for example if 60 out of 100 users answer the following question
Do you love chocolate?
Yes = 60 no = 40
So this to appear in a table with the results from all the other questions contained within the same questionnaire and also an option so it can be viewed as a chart like the one below:
http://chart.apis.google.com/chart?chs=250x100&chd=t:60,40&cht=p3&chl=Yes|No
