Assume query looks OK when you echo it? You're not seeing a literal $id,
are you?
Does an id exist for $id? Is it numeric or char?
Check mysql_affected_rows() - what does it return?
Miles Thompson
At 02:07 PM 1/31/2002 +, Alex Francis wrote:
I have an empty field in a mysql database table
What is $array[answer]. Should that be $array[$answer] ?
-Original Message-
From: Alex Francis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 8:07 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Adding to an empty field
I have an empty field in a mysql database table which
What is $array[answer]. Should that be $array[$answer] ?
Second, change to:
$query = 'UPDATE submissions SET answers = \.$array[$answer].\ where id
= \$id\;
Ya gotta quote that text.
-Original Message-
From: Alex Francis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 8:07
Still having problems
$array[answer] is passed from a previous page with this page.
p align=rightAnswer: TEXTAREA NAME=array[answer] ROWS=8
COLS=60/TEXTAREABR
? echo (TDA HREF=\submit_answer.php?id=$idtask=submit\Submit
Answer/A/TD);?/TR
Have tried changing to array[$answer] on both pages
. We promise not to steal
it and use it ourselves GRIN
-Original Message-
From: Alex Francis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 10:27 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Adding to an empty field
Still having problems
$array[answer] is passed from