SQL Error
| From: | Steve Fitzgerald | Date: | Thu, 02 Aug 2001 13:34:50 +0000 |
| Subject: | SQL Error | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10992@lists.php.net to get a copy of this message | ||
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());
?>