[RESOLVED] Problem in specifying a column

[saathujaya]

I developed a questionnare with text fields,radio buttons and etc using php+html. After the users enter their values that want to update in database.One of my answer in that questionnare has two types of answers those are radio button and text field.for example the answers are
1.Yes 2.No 3. Others(Specify)

I Create table with columns User, AnswerOfQuestion1, AnswerOfQuestion2, .... in database.
I faced a problem when specify the column for described above(Including radio button & text field).I mostly used enum options for othrs.But in this question i've no way.Please help me to solve this problem.

[bastien]

Call it FIELD_question_id and then split the id from the fieldname and process it

[saathujaya]

Sorry i coundn't catch your point.Can you explain that?(What type of column specification want to use?(varchar,char...) or what want to do for that?)

[bastien]

whoops, re-read the questions and now understand the problem...still use emun, but store the text in another column if entered in the other field