I've got a page with text fields where the user can input data (in our situation they are questions).
It would look look something like this:
___________________________________
| Enter your question... | +
|___________________________________|
If the user clicks '+' then another field comes up:
___________________________________
| User's first Question.. |
|___________________________________|
___________________________________
| Enter your next question... | +
|___________________________________|
...And so on. Each of these questions need to be stored in the database, but with the number of questions being dynamic (let's say for arguments sake we limit the max number to 100 questions), what's the best way to achieve this? Should I be creating a new column for each question? Wouldn't that really pollute the database? Ideally I'd have just one column in my database called 'Questions' and just store all the questions in that one column. Is that even possible?
Something like this:
++++++++++++++++++++++++++++++++++++++++++++++
+ id | Questions +
++++++++++++++++++++++++++++++++++++++++++++++
+ 1 | My Question 1,MyQuestion, +
+ 2 | Another Question, And Another one, +
+ . | ...... +
++++++++++++++++++++++++++++++++++++++++++++++
*EDIT* To make it clear - I need to be able to retrieve each of those questions later on and be able to isolate each one individually (e.g. as a PHP array).
*EDIT2*
Additionally because the set of questions are per each user, the bundle of questions need to remain in ONE row. I.e. I can't add the questions in their own rows. In the example above, ID1 is an individual user and My Question 1
and MyQuestion
are that user's questions.