Escaping an "

------=_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--

Re: Escaping an "

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

Re: Escaping an "

Mysql_real_escape_string($bar)

Bastien Koert
905-904-0334
Sent from my iPhone

On 2010-10-16, at 10:41 PM, "Ron Piggott" 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