dangill14 Posted June 15, 2009 Share Posted June 15, 2009 Hey Everyone, Writing an small database site with PHP / MySQL. Having a record update issue. When I issue the following query : UPDATE 'inventory' SET lcn = 'Test', lcn_date = '2009/06/15 - 12:20:49', l_lcn = 'Frame - A01 - SHLF 02', l_lcn_date = '2009/06/14 - 14:26:16', l2_lcn = 'NA', l2_lcn_date = 'NA' WHERE 'index' = '2' I get an error and it seems not to be liking index=2 ... the error is : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index='2' LIMIT 0, 30' at line 1 Is 'index' a forbidden name for a column in a db? Any thoughts would be appreciated. Thanks, Dan. Quote Link to comment Share on other sites More sharing options...
Maq Posted June 15, 2009 Share Posted June 15, 2009 Yes, it is a reserved word - http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html You need to put backticks around it (`Index`), rather than single quotes. Quote Link to comment Share on other sites More sharing options...
dangill14 Posted June 15, 2009 Author Share Posted June 15, 2009 Thanks for the reply! I will test it tonight! Quote Link to comment Share on other sites More sharing options...
Ken2k7 Posted June 16, 2009 Share Posted June 16, 2009 And remove the single quotes around inventory. Quote Link to comment Share on other sites More sharing options...
Maq Posted June 16, 2009 Share Posted June 16, 2009 And remove the single quotes around inventory. That too One more thing, use tags. Improves readability. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.