Re: Syntax error (missing operator) in query expression
| From: | Curt Zirzow | Date: | Thu, 15 Apr 2004 23:24:30 +0000 |
| Subject: | Re: Syntax error (missing operator) in query expression | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-183578@lists.php.net to get a copy of this message | ||
* Thus wrote AgfTech Lists (lists@agftech.com):
> 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('chocsforu@yahoo.com', '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."