Paul Dionne wrote:
> 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 think your query goes wrong, because MySQL uses two single quotes instead
of backslash quote. So, try using
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.
Because the data is save with the \ and with the ', you'll probably have to
change your search to
LIKE "%o\\''mallies%" ).
Try using mysql_escape_string instead of addslashes to store the o'mallies
as is, without the \.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php