Re: addslashes/stripslashes
| From: | Rick Emery | Date: | Tue, 05 Nov 2002 15:36:19 +0000 |
| Subject: | Re: addslashes/stripslashes | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-122787@lists.php.net to get a copy of this message | ||
what happens when you type:
Select * from tblContacts, tblCountries WHERE
(tblContacts.CountryCode=tblCountries.CountryID) AND (Organization LIKE
'%o\'mallies%' )
at the mysql command line?
----- Original Message -----
From: "Paul Dionne" <PDionne@Speakeasy.net>
To: <php-general@lists.php.net>
Sent: Tuesday, November 05, 2002 9:25 AM
Subject: [PHP] addslashes/stripslashes
Hey,
I am trying to develop a search for my database.
I used addslashes when entering the data, and then use addslashes with the
search but nothing comes up:
Select * from tblContacts, tblCountries WHERE
(tblContacts.CountryCode=tblCountries.CountryID) AND (Organization LIKE
'%o\'mallies%' )
I check in the database and o'mallies is indeed there as o\'mallies. And a
search for just mallies works fine.
What gives?
Thanks
Paul
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php