data structure details?

Question

hi i am trying to build something like an interactive application that works like a Q/A. The user is presented with information, and presented with a choice. When they choose, that choice is sent (ajax) to a php script that takes that choice and spits out more questions/options.

Answer 1

I have seen this implemented as

If you wanted to take the surveymonkey approach where you have questions (and the answer options serialised into the table) you would have another table called logic. The fields would be
* id
* question_id
* next_question_id

So when someone answers a question it would look to see if there is any logic associated with that question and feed the next_q_id into a function to get the question. If no logic exists then just get question_id + 1