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), each with 5 answers involved, for users to pick from. But note, depending on the answer they chose, ie whether (a) or (b), or (c), or (d), or (e), they will jump to the next question within the list of about 900 questions. Which means, all 24 questions are repeated throughout the 900 questions. For example, selecting (a) might jump to question 187, or that selecting (e) might jump user to question 350. We indicate the question to jump to, beside the particular answer to every question. At the end of answering every 6 questions, a pair of alphabetical letters, example NJ, will be assigned. Fit NJ into a box. Since 24 questions in total, so 4 sets of 6 questions, and hence 4 boxes involved, each with 2 letters of the alphabet. Store this unique user's 4 boxes of 2 letters each in the database.
Likewise, do the same for other members. So, each member has 4 boxes of 2 alphabetical letters each.
Then, we need to be able to manually choose any two members in the database and compare the corresponding letter in their corresponding box. For example, G from 1st box of member 1 with X from 1st box of member 2. This gives a pair of coordinates, ie GX. You will pick from a table of X and Y coordinates to assign a number to this alphabetical pairing combination. Say, GX from the table corresponds with number 7.
Keep doing this until the 4 squares of 2 letters each from both members yield altogether 8 numbers.
The 8 numbers should be summed up to derive a total. Publish that number on screen.
I will check to ensure that you are accuarate.
Further, back to the first paragraph, I want a separate mySQL table which stores the answer, ie (a) or (b), or (c) or (d) or (e) pertaining to every of the 24 questions that the user selected.
Later, for any 2 members of the site chosen randomly, you must be able to work out the gap, that is the difference in their answers to every question, and save the difference in a third column. For example, 1(a) and 1(a) pertains to a difference of 0, whereas 3(b) and 3(e) pertains to a difference of 3. So, every alphabetical difference is a difference of 1. Therefore, (e) and (a) have a difference of 4. I think you know what I mean.
With the 24 alphabetical differences between 2 individuals computed, show them all on a single page with 24 horizontal bars of varying lengths, labelling them according to the question number therefore.