Re: [PHP] Alter table and add cell at a time.

2002-05-17 Thread Miguel Cruz
update table set answer3=5 where id=2; miguel On Fri, 17 May 2002, Jule wrote: > a question: > > if i have this: > > for ($n = 1; $n <= $quiz[number_answers]; $n++) { > $table = $qcode."_answers"; > $value = $answers["answer".$n]; > $value2 = "answer".$n; > > $query_al

[PHP] Alter table and add cell at a time.

2002-05-17 Thread Jule
a 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 = "INS