As a student CGI programmer, I've been working on an online questionnaire. I have been working so hard to design the mysql db part, still I'm not sure if I've done it right. Still somethings seem to be awkward. Here I'm DESCRIBing the tables for you, then i'm explaining how I inteded to use it: mysql> DESC cral2_questions; +-------------+-------------------+------+-----+---------+----------------+---------------------------------+ | Field | Type | Null | Key | Default | Extra +-------------+-------------------+------+-----+---------+----------------+---------------------------------+ | question_id | int(10) unsigned | | PRI | NULL | auto_increment | question | text | | | | | type | enum('r','c','t') | | | r | | calculate | enum('yes','no') | YES | | NULL | +-------------+-------------------+------+-----+---------+----------------+---------------------------------+ 4 rows in set (0.01 sec) mysql> DESC cral2_answers; +----------------+------------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+-------+---------------------------------+ | answer_id | int(10) unsigned | | | 0 | | | question_id | int(10) unsigned | | | 0 | | | answer | char(200) | | | | | | if_checked | int(10) unsigned | YES | | NULL | | | if_not_checked | int(10) unsigned | YES | | NULL | | +----------------+------------------+------+-----+---------+-------+---------------------------------+ 5 rows in set (0.00 sec) The first table stores questions and the second one stores their answers. If you look at the type column, r stands for RADIO BUTTONED, which means only one of the options could be checked, c means CHECK BOXED or "CHECK ALL THAT APPLY" type of questions, and t stands for TEXT FIELDED, and respondent would have to type something in, which will be matched agains a respective REGEXP. CGI script also calculates the results, and provides an instant feedback depending on the score a student gets. Of course in addition to the above tables, I'll be needing a table for storing each students information by assigning an auto_incrementing number for each student, storing the the students answers, answer key table. Do you guys think I'm making it too much complicated? I can give you the link for the initial step of the application. I developed it for the experts where they rated and provided feedback for each item, according to which we had to fine-tune the questions. Since we have the fine-tuned questions now, I started working on the final part (for students). URL: http://www.ultracgis.com/cgi-bin/cral.v1.cgi You can access the questionnaire from here. And the control panel is at http://www.ultracgis.com/cgi-bin/cral.v1.cgi/ControlPanel I really need experts ideas. Thank you ------------------------- -sherzodR phone: (517) 774-2702 email: [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php