Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

/proc/kallsyms format, sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas

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