RE: [PHP-DB] INSERT Won't Insert
| From: | Craig Vincent | Date: | Wed, 01 Aug 2001 18:46:12 +0000 |
| Subject: | RE: [PHP-DB] INSERT Won't Insert | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10966@lists.php.net to get a copy of this message | ||
If you simplify the query you'll see your error...all those escaped " were
giving me a headache hehe
<snip>
*modified*
$add_co_sql = "INSERT INTO $table_name
(CompanyID, CompanyName, Address, City, StateorProvince,
PostalCode,Region,Country,WebSite)VALUES
('','$CompanyName','$Address','$City','$StateorProvince','$PostalCode','$Reg
ion','$Country','$WebSite'";
</snip>
If you're still missing it, you're missing a ) after '$WebSite'
Sincerely,
Craig Vincent