[SOLVED] my mysql syntax is wrong

[optikalefx]

Im beating my head against a wall here.

 

I am looping to form a sql string and this is the result of that

 

'INSERT INTO cal (company,type,corpParent,hasAflac,anotherAgent,hasHR,contact,position,decision,phone,email,fax,address,adrConf,benefits,totalEmps,fullTimeEmps,notes,whoSet,setDate,time) VALUES (\'wef\',\'wefwefwef\',\'1\',\'1\',\'1\',\'1\',\'qwefqwef\',\'qwefqwef\',\'1\',\'qwefqwef\',\'qwefqwfw\',\'qwefqwef\',\'qwefqwef\',\'1\',\'Health insurance\',\'qwefqwf\',\'qwefqw\',\'qwefqwef\',\'1\',\'1247861162\',\'1247736180\')'

 

 

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 ''INSERT INTO cal (company,type,corpParent,hasAflac,anotherAgent,hasHR,contact,po' at line 1

 

I put that EXACT sql statement into PHPmyAdmin and it works!  So i have no idea what's going on.  I test a SELECT to make sure the db was connected and it is.  I tried with double quotes and not escaping and that that didn't work, i tried using the SET syntax and taht didn't work.  WTF am I doing wrong?

 

Thanks! :confused:

[ldougherty]

What does the entire line of script look like?  Ie where you are running the query that is.

 

I'm thinking the issue may be with the leading ' as the query should be something along the lines of mysql_query("insert bla bla");

[optikalefx]

never mind, i took 5 minutes and figured it out.  I was putting Quotes in front and at the end which was not correct.  I'm an idiot.