We need to set up an online personality quiz site and store the respondents' answers in mysql database. It must be in php and using mysql tables.
We have a list of 24 multiple-choice questions (MCQ), distributed amongst 936 questions, with repetitions per question of course. Which means, all 24 questions are repeated throughout the 936 questions Each question has 5 answers involved, for users to pick from. But note, depending on the MCQ answer they have chosen, they shall jump suddenly to a specific question within the list of about 936 questions, and after answering it, jump again to suddenly another question.
After answering 1st question, he is directed to answering 3 more questions.
Then go to answer 2nd question, and he is directed to answering 3 more questions too.
By the time he has answered the 6th question, he is directed to answering 3 last questions.
Therefore, 6 * 4=24 questions. That is how user answers only 24 questions within this list of specifically 936 questions.
Note, after answering each set of 4 questions above, he is given a result with 2 alphabetical letters, say X E, and you will enter it into a row on a table 1st column. So with 6 sets of 4 questions per set above, therefore you will enter a pair of alphabetical letters into 6 columns on a single row, ie 6 pairs of alphabetical letters.
Store this in a MySQL table.
For more info, please download the attachment to read the instructions in MS Word Document. I can help ease any query.