RSS Forums RSS
Please support our MySQL advertiser: Programming Forums

Error with Update

Join Date: Jun 2005
Location: Kansas City, Missouri, USA
Posts: 345
Reputation: Troy is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 4
Troy's Avatar
Troy Troy is offline Offline
Posting Whiz

Re: Error with Update

  #2  
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
Reply With Quote  
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 12:30 am.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC