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. Link to comment https://forums.phpfreaks.com/topic/162278-mysql-query-issue/ 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. Link to comment https://forums.phpfreaks.com/topic/162278-mysql-query-issue/#findComment-856523 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! Link to comment https://forums.phpfreaks.com/topic/162278-mysql-query-issue/#findComment-856547 Share on other sites More sharing options...
Ken2k7 Posted June 16, 2009 Share Posted June 16, 2009 And remove the single quotes around inventory. Link to comment https://forums.phpfreaks.com/topic/162278-mysql-query-issue/#findComment-856745 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. Link to comment https://forums.phpfreaks.com/topic/162278-mysql-query-issue/#findComment-856817 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.