Hi all,
I have set up a quiz database...
Tables:
questions{question_ID(P), question_text}
answers{answer_ID(P), answer_text, question_ID(F), correct}
quiz{quiz_ID(P), student, question_ID(F)}
I am creating an admin interface to allow admin to add new questions. Should work like this...
All in one html form..
1/ Enter the question into textfield
2/ Enter relevant multiple choice answers(textfield)
3/ Mark the correct answer(radio group?)
Then each answer and relevant question_ID should be inserted into the answers table along with either a 'Yes' value if it's the correct answer or a 'No' value if incorrect.
My main problem is marking the correct answer and inserting the relevant values for each answer.
Any ideas on this?
Thanks.
