I keep getting the following SQL error:
You have an error in your SQL syntax near ')' at line 14
Line 14 is: '$FirstName', so the error must correspond to a different part
of the code.
Any ideas?
$add_contact_sql = "INSERT INTO $table_name
(ContactID, FirstName, LastName, Title, WorkPhone,
HomePhone,Mobile,EmailName,Birthday,CompanyID)
VALUES
('',
'$FirstName',
'$LastName',
'$Title',
'$WorkPhone',
'$HomePhone',
'$Mobile',
'$EmailName',
'$Birthday',
'$ContactID',
)";
$result = @mysql_query($add_contact_sql, $connection) or die
(mysql_error());
?>
You have an error in your SQL syntax near ')' at line 14
Line 14 is: '$FirstName', so the error must correspond to a different part
of the code.
Any ideas?
$add_contact_sql = "INSERT INTO $table_name
(ContactID, FirstName, LastName, Title, WorkPhone,
HomePhone,Mobile,EmailName,Birthday,CompanyID)
VALUES
('',
'$FirstName',
'$LastName',
'$Title',
'$WorkPhone',
'$HomePhone',
'$Mobile',
'$EmailName',
'$Birthday',
'$ContactID',
)";
$result = @mysql_query($add_contact_sql, $connection) or die
(mysql_error());
?>