[SOLVED] MYSQL 1064 Error MSG . . . Need someone to view my code for soundness

[mcjce46]

Having problems getting past this particular error msg....Need a little help

 

1064 - Query Failed: 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 'of web Testing,Street Address Apt #,City,ST,Zip,9999999999,mac@macmagroup.net,t' at line 4

 

$i = "INSERT INTO 1campMembers
        (FNAM,MI,LNAM,EDU,MADDR,TOWN,ST,ZCODE,PHNUM,EML,SKLS,MSC)
        VALUES
        ($fnam,$mnam,$lnam,$edu,$maddr,$town,$st,$z,$ph,$emailaddr,$talent,$other)";

 

I have validating that I am not using any of the 'Reserved Words' . . .

[elflacodepr]

what you are showing doesnt say much, can u please post the code?

[mcjce46]

The error is occurring on the INSERT INTO statement.....

What more do you need to solve?

[PFMaBiSmAd]

String values need to be enclosed in single-quotes so that they are treated as strings and not keywords or identifiers.

[mcjce46]

So, I should enclose my php variable within ' 's ?

[fenway]

So, I should enclose my php variable within ' 's ?

Yes.