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