jc2008 Posted May 22, 2008 Share Posted May 22, 2008 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 Link to comment https://forums.phpfreaks.com/topic/106754-mysql-google-charts-api/ Share on other sites More sharing options...
DyslexicDog Posted May 22, 2008 Share Posted May 22, 2008 It looks like you could use that link as your img src. Link to comment https://forums.phpfreaks.com/topic/106754-mysql-google-charts-api/#findComment-547251 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.