Re: Insert Query PROBLEMS

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux