Jump to content

MySQL Query Issue


dangill14

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.