Member Avatar for ashneet

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
  • 150 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by ashneet
Member Avatar for Troy

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.

Member Avatar for ashneet

Thanks A lot

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.