storing survey data in the db

[Tonka1979]

Hi guys!

I have a web page containing a form with many questions and I let the user specify one or a few answers by using either radio buttons or checkboxes. I need to know how to store the information (their answers) in a database in case of questions with multiple choices (checkboxes). Should I concatenate the strings corresponding to each checkbox the user has checked for a certain question and store that string in my db or how should I do it? Pls give me some tips.

Also some survey code samples if you know would be appreciated. Thanks!

[Weedpacket]

Have a separate table with at least three columns: one for the user ID, one for the question ID, and one for the checkbox ID. If user 1113 checks boxes 1, 3, and 5 of question 9; there will be three rows in the table

userID | questionID | checkboxID
-------+------------+-----------
1113   |     9      |     1
1113   |     9      |     3
1113   |     9      |     5

And there will be other rows for other users and other questions.

And there's a database forum here for database questions.

[Tonka1979]

Thank you!