You have a different row for each answer because each answer has its own INSERT. A solution would be to do a single INSERT (with quiz question or some other data) and then for each answer do an: UPDATE $table SET $value2='$value' WHERE id='$question_id'
You'd just have to keep track of the row ID (which would be the primary key in this example). Nice to see quiz software being built by an .EDU! Ron Jamison -----Original Message----- From: Jule [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 5:27 PM To: [EMAIL PROTECTED] Subject: Alter table and add cell at a time. Quick little followup question: if i have this: for ($n = 1; $n <= $quiz[number_answers]; $n++) { $table = $qcode."_answers"; $value = $answers["answer".$n]; $value2 = "answer".$n; $query_alter_table = "ALTER TABLE $table ADD $value2 TEXT NOT NULL"; $query_add_answers = "INSERT INTO $table ($value2) VALUES('$value')"; if (mysql_db_query($database_glob, $query_alter_table, $link_glob)) { if (mysql_db_query($database_glob, $query_add_answers, $link_glob)) { echo "Answer $n: $value has successfully been added to the Quiz<br>\n"; } else { echo mysql_error() ." 1<br>"; } } else { echo mysql_error()." 2<br>"; } } How do I get the $value to be in the same row as the preceding one? now it comes like this: +----+---------+---------+---------+---------+ | id | answer1 | answer2 | answer3 | answer4 | +----+---------+---------+---------+---------+ | 1 | answer1 | | | | | 2 | | answer2 | | | | 3 | | | answer3 | | | 4 | | | | answer4 | +----+---------+---------+---------+---------+ so it's like this? +----+---------+---------+---------+---------+ | id | answer1 | answer2 | answer3 | answer4 | +----+---------+---------+---------+---------+ | 1 | answer1 | answer2 | answer3 | answer4 | +----+---------+---------+---------+---------+ thanks, Jule On Friday 17 May 2002 19:17, you wrote: > Hello, > > Try using "NOT NULL". As weird as MySQL can be, don't think it is > that NUTty. =) > > Harrison > > ----- Original Message ----- > From: "Jule" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, May 17, 2002 7:00 PM > Subject: "ALTER TABLE $table ADD $value2 TEXT NUT NULL" > > > Hey i'm getting this error: > > You have an error in your SQL syntax near 'NUT NULL' at line 1 > > when i run this query, > > "ALTER TABLE $table ADD $value2 TEXT NUT NULL" > > from the documentation i understood that this was the correct > notation. > > any ideas? > thanks > Jule > -- > > |\/\__________________________/\/| > | Jule Slootbeek | > | [EMAIL PROTECTED] | > | http://blindtheory.cjb.net | > | __________________________ | > |/\/ \/\| > > --------------------------------------------------------------------- > 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 > > > > > > --------------------------------------------------------------------- > 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 -- |\/\__________________________/\/| | Jule Slootbeek | | [EMAIL PROTECTED] | | http://blindtheory.cjb.net | | __________________________ | |/\/ \/\| --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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