* Thus wrote AgfTech Lists ([EMAIL PROTECTED]):
> Hi All
>
> Following is the INSERT statement I am executing,
>
>
> <<<<<<<<<<<< snip >>>>>>>>>>>>>>
>
> INSERT INTO customer (email, password, handle, fname, lname, company,
> tax_id, addr1, addr2, city, state, zipcode, country, dayphone, evephone,
> fax, paymethod, cardname, cardnum, expmonth,expyear ,ship_addr1,
> ship_addr2,ship_city ,ship_state,ship_zipcode ,ship_country, [date],
> hear_about_us, mailing_list, email_notification)
> VALUES('[EMAIL PROTECTED]', 'aman', 'none' ,'Am\'an' ,'raheja' ,'',''
> ,'1317','esid' ,'edw','IL' ,'62025','USA' ,'6186550690','' ,'','VS'
> ,'Am\'an Raheja','4111111111111111' ,05,06 ,'','' ,'','00','','USA',
> '2004-04-15 18:05:50', '', 'Y', 'Y');
> <<<<<<<<<<<< snip >>>>>>>>>>>>>>
MSAccess wants quotes escaped with '' not \'
You have a few options:
1. turn off magic_quotes_gpc, and replace ' => ''
str_replace( "'", "''", $var);
2. str_replace( "'", "''", stripslashes($var));
3. turn on magic_quotes_sybase
Curt
--
"I used to think I was indecisive, but now I'm not so sure."
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
