Hi, suggestions welcomed
I have an online quiz(zes) to make for a site. The quizzes themselves will not change much I have been throwing around the idea in my head on how to best accomplish this. All questions will be displayed on a single page with a submittal showing number of answers correct, percentage, and answers/explanation.
DB first:
Idea 1:
question table: question_id, question_text, question_answer, question_explanation, question_url
solution table: solution_id, question_id, solution_text
Idea 2:
question table: question_id, question_text, question_answer, question_explanation, question_url, question_solution1, question_solution2, question_solution3, question_solution4
The most a question can have is four answers (maybe change in the future) but some only have two; this leads to me preferring Idea 1.
Now the question is, what is the best way to get this information out of th
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --