Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

WWWXXXAPC, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text, WWWXXXAPC., XXXCNZZZ

Links

XODOX
Impressum

#1: Escaping an "

Posted on 2010-10-17 04:41:12 by ron.piggott

------=_NextPart_000_00AC_01CB6D83.3BF00480
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

For a query similar to:

SELECT * FROM `tablle` WHERE `column` LIKE 'Sally's Hair Parlor'=20

how do I escape the ' for 's?


------=_NextPart_000_00AC_01CB6D83.3BF00480--

Report this message

#2: Re: Escaping an "

Posted on 2010-10-17 06:09:34 by David Robley

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?

It's in the manual - assuming you use mysql, see
http://php.net/manual/en/book.mysql.php


Cheers
--
David Robley

"I just won 1000 dollars," Tom said grandly.
Today is Setting Orange, the 71st day of Bureaucracy in the YOLD 3176.


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Report this message

#3: Re: Escaping an "

Posted on 2010-10-17 15:10:17 by Phpster

Mysql_real_escape_string($bar)

Bastien Koert
905-904-0334
Sent from my iPhone

On 2010-10-16, at 10:41 PM, "Ron Piggott" <ron.piggott@actsministries.org> w=
rote:

> For a query similar to:
>=20
> SELECT * FROM `tablle` WHERE `column` LIKE 'Sally's Hair Parlor'=20
>=20
> how do I escape the ' for 's?
>=20

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Report this message