Re: Insert Query PROBLEMS

From:	Philip Thompson	Date:	Mon, 13 Sep 2004 13:55:00 +0000
Subject:	Re: Insert Query PROBLEMS
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-36172@lists.php.net to get a copy of this message

Aaron, I agree with what Mark said. But I just want to say what I noticed off hand... On Sep 10, 2004, at 11:13 AM, Aaron Todd wrote:

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')

When I do an UPDATE and refer to these columns, I do not include the single quotes (or tick marks) around my fields, and it works fine. But like Mark said, cleaning it up (1 per line) might also help - that's just personal preference. ~Philip