Re: Help on questionnaire

You've not told us anything you've tried so far, this reads like a poor specification for something you've been asked to do for work/homework. This site isn't a code writing service.

Suggestions for places to start:

Ovid's CGI Course from CGI Programming in the tutorials section.
HTML::Template Tutorial from Framework, Templating, and Content Management Systems in the tutorials section.
The fine art of database programming from Database Programming in the tutorials section.
And potentially Installing Modules, should you need any help with that.

"As it will be web based script I'll be using MySQL DB. "

Note that other open source database platforms are avaiable :)

If you have any specific questions show us the code you have and the error messages you experience. See How do I post a question effectively?.

Martin

Comment on Re: Help on questionnaire

Replies are listed 'Best First'.
Re^2: Help on questionnaire by Anonymous Monk on Oct 14, 2009 at 18:57 UTC
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	[reply]
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]