Hi All,
I am getting a sql syntax error, and I cannot find it.
Here is the error:
Here is the code:
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 '2005-11-02', '3:55 PM')' at line 1
$sql ="insert into Feedback";
$sql .="(Surname, FirstName, LastName, Title, SubjectTaught, School, Address, AddressType, City, State, Zip, EmailAddress, Phone, PhoneType, Greed, Scaring, Freeloaders, AmericaOne, Washington, AverageStudents, HowManyYrs, MostValuable, MaterialEnhancements, AddServices, Reactions, PostComments, SharedYes, SharedNo, SharedQty, AddFormsYes, AddFormsNo, AddFormsQty, AddBrochYes, AddBrochNo, AddBrochQty, Date, Time)";
$sql .="values('$Surname', '$FirstName', '$LastName', '$Title', '$SubjectTaught', '$School', '$Address', '$AddressType', '$City', '$State', '$Zip', '$EmailAddress', '$Phone', '$PhoneType', '$Greed', '$Scaring', '$Freeloaders', '$AmericaOne', '$Washington', '$AverageStudents', '$HowManyYrs', '$MostValuable', '$MaterialEnhancements', '$AddServices', '$Reactions', '$PostComments', '$SharedYes', '$SharedNo', '$SharedQty', '$AddFormsYes', '$AddFormsNo', '$AddFormsQty', '$AddBrochYes', '$AddBrochNo', $AddBrochQty', '$Date', '$Time')";
if(!mysql_query($sql)){
echo mysql_errno().'<br>you need some MySQL HELP<br><br><br>'.mysql_error().'<br><br>';
I am totally stumped here. I checked my table, code, everything.
Any help would be GREATLY appreciated.
Thanks,
Don
