0

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

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... :confused:

2
Contributors
2
Replies
3
Views
12 Years
Discussion Span
Last Post by ashneet
0

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:

$sql = "UPDATE Catalog SET [Table] = 'Harrow_VH' WHERE Name = 'Variable Action Harrow'";

But do yourself a favor, do not name any objects in your database using any of the reserved words.

0

Thanks A lot

Sorry about the wrong way of writing as i was in a hurry. ;)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.