gary00ie Posted June 18, 2011 Share Posted June 18, 2011 Hi, I know this is a very simple problem,but,I can't see the issue: INSERT INTO job_postings ( `position`, `employer`, `city`, `state`, `email`, `description`, `contact`, `website`, `expiry`, `created_at`, `modified_at` ) VALUES(`Gary Test1`, `Gary Test2`, `Gary Test3`,`FL`, `[email protected]`, `Gary Test desc`, `Gary Test4`, `http://www.site.com`, now(), now(), now() ) What am I doing wrong? With this string I'm getting the error: #1054 - Unknown column 'Gary Test1' in 'field list' I've been doing sql for a long time and just thinkI've been looking at this too long... Also, apologies for the simpleton question, you guys are always just a great help. Thanks in advance for any help. -Gary Link to comment https://forums.phpfreaks.com/topic/239744-fresh-eyes-needed-for-this-sql-string/ Share on other sites More sharing options...
Pikachu2000 Posted June 18, 2011 Share Posted June 18, 2011 The values being inserted don't get enclosed in backticks. If they're strings they get enclosed in quotes; numbers should be validated and left unquoted. Link to comment https://forums.phpfreaks.com/topic/239744-fresh-eyes-needed-for-this-sql-string/#findComment-1231546 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.