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
uote that text. > > -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 needs to

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

2002-01-31 Thread Rick Emery
L 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 needs to have text inserted when my client answers an email. The code is as follows $query = 'UPDATE submissions S

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

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

[PHP-DB] Adding to an empty field

2002-01-31 Thread Alex Francis
I have an empty field in a mysql database table which needs to have text inserted when my client answers an email. The code is as follows $query = 'UPDATE submissions SET answers = "$array[answer]" where id = "$id" '; // $query = $query . " where id = $id "; // echo ("The query is: $query\n"