I am a complete novice with MySQL but have been persevering with it for a project I am doing at work. I have created a results server to analyse and collect data I receive from quizzes I have created using QuestionWriter HTML5.
I have figured out how to run a query and have a vague understanding of the 'language' used.
The questions I have created are multiple choice, I want to be able to run a query on a specific question so i can see how many people have answered a, how many people answered b, etc. I have used the following query which I believe is half of the solution:
WHERE 'QuestionReference' LIKE ...............
......... is just whatever the specific question reference is.
This query displays to me every single persons answer with the question reference repeated. What I want is a two column table which shows me the answer and how many times it has been chosen. So for 20 people the result of the query might look like.
I hope that is clear! If anyone can suggest a query for me to use or just some advice would be great.
Thanks in advance,