RE: [PHP-DB] Adding to an empty field

2002-01-31 Thread Rick Emery
[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 a previous page with this page. Answer: Submit Answer");?> Have tried changing to array[$an

Re: [PHP-DB] Adding to an empty field

2002-01-31 Thread Alex Francis
Still having problems $array[answer] is passed from a previous page with this page. Answer: Submit Answer");?> Have tried changing to array[$answer] on both pages without any luck. Changed the code to: $query = "UPDATE submissions SET answers = \"".$array[$answer]."\" where id = \"$id\""; and

RE: [PHP-DB] Adding to an empty field

2002-01-31 Thread Rick Emery
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, 200

RE: [PHP-DB] Adding to an empty field

2002-01-31 Thread Rick Emery
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 need

Re: [PHP-DB] Adding to an empty field

2002-01-31 Thread Miles Thompson
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 tabl