I am working on a rule to find out which question has the highest correct answer. Not sure how to work with this. But here is an explanation of what I have so far and what I want my program to do.

I have question and answer table
Question: questionid,QuestionName, Questionchoice1,Questionchoice2, Questionchoice3, Questionchoice4,answer1,answer2,answer3,answer4
Answer: answerid, Answer1,Answer2,Answer3,Answer4,questionid

Question table is where the admin will add question,choice for these and the answers.
Answer table will have answers to these question that were taken by students.

So now what I want to do is, get all the answer for each question and find out which question was answered correctly the most.

7 Years
Discussion Span
Last Post by Akash Saikia

where is student id, how will you know, that who answered what?

Edited by urtrivedi: n/a


Why do you have multiple fields for storing one question's answer??
like you have answer1,answer2,answer3 and answer4...

do you want to provide multiple answers to be true for one question?

Please clarify this. :)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.