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`, `gary.dunne1@gmail.com`, `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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.