I would structure things differently. Have you thought about making each question a record/row in a table? Then if you add or remove a question, you don't have to change you table structure or your code if you do it right. You could also then easily compile stats on a per question basis. Like how many people answer 4 for question #25 or how many people got the right/wrong answer. It's a little harder to program, but it would be the most flexible.
> > hi all, > i am working on Mysql to make a table to store following data > Varchar Semester, > Varchar Name, > Varcahr Course, > int Enroll, > int Responses, > int Question#22, > int Question#23, > int Question#24, > int Question#25, > int Question#26, > int Question#27, > int Question#28, > int Question#29, > int Average > > One Sample Data row is > XYZ, 1999,ABCDEF,990,6,4,4.75,3.33,4.67,4.00,4.25,4.00,4.25,4.50,4.22 > > My question is, can i store the data for fields Question#22.....Question#29 > in one data field in table (Say TABLE1), and when i retrieve the field, i> > should be able to break them into individual questions#, take each Question# > into > PHP variables and work on it. > Any idea how to do that? My aim is to reduce the number of columns for the > TABLE1. Your answer will be appreciated. > >> thnaks >> Imrani >> >> > > --------------------------------------------------------------------- > 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 > -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 --------------------------------------------------------------------- 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
