Re: [PHP-DB] Escaping an '

2010-10-17 Thread Bastien
Mysql_real_escape_string($bar) Bastien Koert 905-904-0334 Sent from my iPhone On 2010-10-16, at 10:41 PM, "Ron Piggott" wrote: > For a query similar to: > > SELECT * FROM `tablle` WHERE `column` LIKE 'Sally's Hair Parlor' > > how do I escape the ' for 's? > -- PHP Database Mailing List (h

[PHP-DB] Escaping an '

2010-10-16 Thread Ron Piggott
For a query similar to: SELECT * FROM `tablle` WHERE `column` LIKE 'Sally's Hair Parlor' how do I escape the ' for 's?

Re: [PHP-DB] Escaping Characters help needed

2005-09-23 Thread Micah Stevens
Just out of curiosity, your method looks like it should work, what's the mysql error message? -Micah On Friday 23 September 2005 2:28 pm, Chris Payne wrote: > Hi there everyone, > > Can any of you see why the below will not insert into my database? > > Hann Heritage Homes' Fall Circuit entry.

Re: [PHP-DB] Escaping Characters help needed

2005-09-23 Thread Micah Stevens
look at: mysql_escape_string(); On Friday 23 September 2005 2:28 pm, Chris Payne wrote: > Hi there everyone, > > Can any of you see why the below will not insert into my database? > > Hann Heritage Homes' Fall Circuit entry. Fabulous ranch floorplan w/walkout > basement. Stunning great room w/F

[PHP-DB] Escaping Characters help needed

2005-09-23 Thread Chris Payne
Hi there everyone, Can any of you see why the below will not insert into my database? Hann Heritage Homes' Fall Circuit entry. Fabulous ranch floorplan w/walkout basement. Stunning great room w/FP, dramatic dining room, den, screened porch. Mullett kitchen with glazed birch cabinets and granite.

RE: [PHP-DB] escaping line brakes

2002-07-16 Thread joakim . andersson
> From: Andy [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 2:45 PM > Hi there, > > I am putting text into a mysql db from a form field. I do include the > linebrakes with line2br. > > Now I would like to create an interface where I could load > the text into the > form again to edi

[PHP-DB] escaping line brakes

2002-07-16 Thread Andy
Hi there, I am putting text into a mysql db from a form field. I do include the linebrakes with line2br. Now I would like to create an interface where I could load the text into the form again to edit it. Unfortunatelly it includes some wired chars like \br into the text. How can I get rid of th

Re: [PHP-DB] Escaping queries in php using InterBase

2001-08-22 Thread Yves Glodt
On Wednesday 22 August 2001 14:34, Patrik Wallstrom wrote: > On Wed, 22 Aug 2001, Yves Glodt wrote: > > Hello, > > > > I'm in trouble with my current project which uses Interbase as > > backend. (php.ini: magic_quotes_sybase = On) > > When I insert a string containing a ', like Beverly D'Angelo, >

Re: [PHP-DB] Escaping queries in php using InterBase

2001-08-22 Thread Patrik Wallstrom
On Wed, 22 Aug 2001, Yves Glodt wrote: > Hello, > > I'm in trouble with my current project which uses Interbase as backend. > (php.ini: magic_quotes_sybase = On) > When I insert a string containing a ', like Beverly D'Angelo, > php saves it with two ' > When I insert it with two ', it gets saved

[PHP-DB] Escaping queries in php using InterBase

2001-08-22 Thread Yves Glodt
Hello, I'm in trouble with my current project which uses Interbase as backend. (php.ini: magic_quotes_sybase = On) When I insert a string containing a ', like Beverly D'Angelo, php saves it with two ' When I insert it with two ', it gets saved with four ' Short: php multiplies all the ' by facto