RE: [PHP] URGENT
| From: | Martin Towell | Date: | Tue, 18 Jun 2002 23:35:32 +0000 |
| Subject: | RE: [PHP] URGENT | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-102828@lists.php.net to get a copy of this message | ||
you might need to place a space before WHERE
-----Original Message-----
From: Phil Reid [mailto:phil@philip-reid.com]
Sent: Wednesday, June 19, 2002 9:33 AM
To: php-general@lists.php.net
Subject: [PHP] URGENT
I am in urgent need of help! (AGAIN)
Can anyone spot anything wrong with this query?
$sql = "UPDATE IGNORE customer SET forename = '$forename', surname =
'$surname', e-mail ='$email', company = '$company', homephone =
'$homephone', workphone = '$workphone', mobilephone = '$mobilephone',
address1 ='$address1', address2 ='$address2', address3 = '$address3',
local = '$local', city = '$city', postcode = '$postcode', id =
'$id'";
$sql .= "WHERE username='$username'";
mysql_query( "$sql");
I need to get it working NOW!
I will be very grateful if I receive the same level of help as before.
Thanks a lot.
Phil Reid