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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
