Insert Query PROBLEMS
| From: | Aaron Todd | Date: | Fri, 10 Sep 2004 16:13:52 +0000 |
| Subject: | Insert Query PROBLEMS | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-36145@lists.php.net to get a copy of this message | ||
I'm trying to run an INSERT query on my mysql database and it isnt working.
Here is the query:
$updatequery = "UPDATE
users
SET
('company','fname','lname','address1','address2','city','state','zip','phone','extension','fax','email')
=
('".$_POST['company']."','".$_POST['fname']."','".$_POST['lname']."','".$_POST['address1']."','".$_POST['address2']."','".$_POST['city']."','".$_POST['state']."','".$_POST['zip']."','".$_POST['phone']."','".$_POST['extension']."','".$_POST['fax']."','".$_POST['email']."')
WHERE
ID='".$_GET['record']."'";
When I echo this it looks fine, but nothing in the database reflects the
change. I have tried cutting it down to only the first 2 colums and then it
works. But I cant see a syntax error that would cause this not to work.
Does anyone have any idea why this might not be working.
Thanks,
Aaron