On Mon, 2002-07-15 at 21:01, Salve Tinkerworth wrote:
> 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')";
Try ('$new_campaignid',....) instead
<snip>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
