When my insert into function executes I receive this error...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 'Mr.', 'BK-11125', 'Lol', '40788' '', '')' at line 2! With that said, I am reading a spreadsheet with PHPExcel and I am inserting data from the spreadsheet cells into a remote db.
$dbc = mysql_query("INSERT INTO coverages ( Name, Comments, Premium, Effective_Date, Expiration_Date, Broker_First_Name , Broker_Middle_Initial, Broker_Last_Name, Broker_Suffix, Broker_License_Number, DateCreated) VALUES ('$rw1', '$rw2', '$rw3', '$rw4', '$rw5, '$rw6', '$rw7', '$rw8', '$rw9' '$rw10', '$rw11')") or die (mysql_error());
Any thoughts as to what causes this error?