Error with Update

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 391,859 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,584 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 1595 | Replies: 2

•

Join Date: Jun 2005

Location: USA

Posts: 147

Reputation: ashneet is an unknown quantity at this point

Rep Power: 4

Solved Threads: 1

ashneet

Offline

Junior Poster

Error with Update

Jul 26th, 2005

This sql command is for PHP but this is what happen to it after php had made chenges:

Help with Code Tags

(Toggle Plain Text)

UPDATE Catalog SET Table='Harrow_VH'  WHERE Name='Variable Action Harrow'

I get this error both places php and mysql client it self:

MySQL said:

You have an error in your SQL syntax near 'TABLE = 'Harrow_VH' WHERE Name = 'Variable Action Harrow'' at line 1

Please help as i have no idea what to do and tried everthing i knew...

•

Join Date: Jun 2005

Location: Kansas City, Missouri, USA

Posts: 344

Reputation: Troy is an unknown quantity at this point

Rep Power: 4

Solved Threads: 4

Troy

Offline

Posting Whiz

Re: Error with Update

Jul 27th, 2005

Your question is constructed in way making it difficult to read, but I have 1 thing for you.

"table" is a reserved word in MySQL. You should not name a colulmn "table". You can use reserved words, but in your queries, you'll have to put brackets around the reserved word like this:
[PHP]
$sql = "UPDATE Catalog SET [Table] = 'Harrow_VH' WHERE Name = 'Variable Action Harrow'";
[/PHP]
But do yourself a favor, do not name any objects in your database using any of the reserved words.

Troy Wolf is the author of SnippetEdit. "Website editing as easy as it gets." IX Web Hosting