Online quiz help

[ahmedkl]

Hello everyone i am new here . I want to make an online quiz website . The functionality will be like:

Admin can add number of questions

The question

User log's in (can do this part)

 

The problem is i don't know how many questions there will be so how do i get the name of the radiobuttons from the generated quiz page?

[premiso]

Well you have to know the number of questions, so you just simply do a for loop of the number of questions, or if the data is being stored in a database, while loop from the DB of the number of questions.

[ignace]

quizzes (quiz_id, ..)

quizzes_questions (question_id, quiz_id, ..)

quizzes_answers (answer_id, question_id, ..)

[ahmedkl]

thanks ignace , now for the user part what should i do?get the answers from him store it in another table or first i should compare it with the answer table and then store it in another table?

[ignace]

quizzes_results (user_id, quiz_id, question_id, answer_id) -- where answer_id is the chosen answer

[ahmedkl]

thanks a bunch ignace i am almost done with the site , another thing i wanted to ask that how can i apply the cascade update/delete option in mysql to a relation?other then writing query i want to know if there's some visual way to do it

 

[ignace]

How do you mean visual? InnoDB does this automatically when a parent reference has been updated or deleted in which - in the case of CASCADE - updates all child's or deletes all child's.

[ahmedkl]

that doesn't seem to happen in mysql

[ignace]

Are you sure you have InnoDB as the engine or MyISAM for your tables?

[ahmedkl]

thanks ignace , it worked with InnoDB , all stuff solved thankyou again