Re^2: Help on questionnaire

I think you did not get the point

I am not looking for someone to write a code for me, I am asking a question about the proper table structure that suits storing 600 answers / per user

Should I use 600 column table, or You've got some other idea ?

the other question was about the look-and-feel of the questionnaire ... answering 600 questions is sort-off boring and my solution was to use "save-state" so you don't have to answer all the questions in 1 day, is this the only solution or you have something else that works better??

I am looking for ideas not for codes and I showed you my effort

I am open to suggestions

Comment on Re^2: Help on questionnaire

Replies are listed 'Best First'.
Re^3: Help on questionnaire by gmargo (Hermit) on Oct 14, 2009 at 19:13 UTC
Obviously a 600 column table is inappropriate, because tomorrow it will be 601. Sounds like about three tables with just a few columns each. `user table user_id user_name, other login details (index user_id) question table question_id question answer (index question_id) answer table user_id question_id answer (index user_id+question_id)` [download]	[reply] [d/l]