PHP4/mssql_query INSERT problems
| From: | Salve Tinkerworth | Date: | Tue, 16 Jul 2002 01:01:27 +0000 |
| Subject: | PHP4/mssql_query INSERT problems | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20566@lists.php.net to get a copy of this message | ||
Why do I keep getting messages like:
INSERT INTO OPS (CampaignID,[Description],PhoneInventory,URLInventory)
VALUES (463,'In and Out','','')
Warning: MS SQL message: Line 1: Incorrect syntax near '463'. (severity 15)
in c:\inetpub\wwwroot\intranet2\ccp\campaign_edit.html on line 62
Warning: MS SQL: Query failed in
c:\inetpub\wwwroot\intranet2\ccp\campaign_edit.html on line 62
for a simple insert like:
$sql2="INSERT INTO OPS
(CampaignID,[Description],PhoneInventory,URLInventory) VALUES
($new_campaignid,'$Description','$PhoneInventory','$URLInventory')";
echo $sql2;
$result=mssql_query($sql2);
$error=mssql_query('SELECT @@ERROR As ErrorCode');
if($error['ErrorCode'] != 0) {
echo $error['ErrorCode'];
echo $sql2;
die('Inserting OPS failed');
}