[PHP-DB] PHP4/mssql_query INSERT problems

[Salve Tinkerworth]

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');
}



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php