Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
06-27-2009, 02:24 AM #1
- Join Date
- Apr 2003
- in my house
- Thanked 201 Times in 197 Posts
problem matching values with apostrophe
I am querying a MySQL table to match a form/session value with a col value.
The two values to be matched are "john's" (without the double quotes)
when I run the query the apostrophe needs to be escaped?? but then there is no match
what way should I change the query please?
SELECT bd.phone_number , bd.fax_number , bd.email_address , bd.web_url FROM business_details bd WHERE bd.grp_name = '$selected_group_name' and bd.premises = '$selected_premises_name'