Create a Quiz Template

I need you to create a template in PHP/mySQL. I need it to show one question after other question on the same page. The template should random pick the question by level. I have set up the rules before going to the next page to print result. I need you to storage in the database like this: Table - Answer Question_Asked(14, 20, 47, 30, etc) Answer_Response(2, 3, 1, 1, 4, etc) Correct_InCorrect (I, C, C, I, C, etc) Using this result, I need you to print the result in chart. Here are the rules that I need to set up: At staring point, the exam always starts at level 2. • First three answers are correct, go to level 3 • First three answers are incorrect go to level 1 At either level 3 or level 1: • If only 3 out of 6 correct answers, go the same level • If only 4 out of 6 correct answers, go up level • If only 2 out of 6 correct answers, go down level • Stop when • Got 3 out of 6 correct answers twice. • If got 2 out of 6 correct answers at level 1. • Got the first 6 incorrect answers then stop at Level 1. • If only 2 out of 6 correct answers, go down then STOP • Arrive to Level 6 example1: 1. Start at Level 2, did not get the first three correct or incorrect answers, then stay on level 2 2. Got 4 out of 6 correct answers, move to level 3 3. Got 3 out of 6 correct answers, stay on level 3 4. Got 4 out of 6 correct answers, move to level 4 5. Got 2 out of 6 correct answers, move to level 3 6. STOP, result is level 3. There is no question provided and exit from the exam. example2: 1. Start at Level 2, got 3 straight correct answers. Move to level 3. 2. Got 3 out of 6 correct answers, stay on level 3. 3. Got 2 out of 6 correct answers, move to level 2. 4. STOP, result is level 2. There is no question provided and exit from the exam. example3: 1. Start at Level 2, got 3 straight incorrect answers. Move to level 1. 2. Got 4 out of 6 correct answers, move to level 2. 3. Got 3 out of 6 correct answers, stay on level 2. 4. Got 4 out of 6 correct answers, move to level 3. 5. Got 4 out of 6 correct answers, move to level 4. 6. Got 2 out of 6 correct answers, move to level 3. 7. STOP, result is level 3. There is no question provided and exit from the exam. example4: 1. Start at Level 2, got 3 straight correct answers. Move to level 3. 2. Got 3 out of 6 correct answers, stay on level 3. 3. Got 3 out of 6 correct answers, stay on level 3. 4. STOP, result is level 3. There is no question provided and exit from the exam. ---------- Ask me if you have any questions to clear this up.