I'm using php and I can't figure out how to search for exact names. some values in the variable may contain apostrophes. Here's my code so far:
$query1 = mysql_query("SELECT * FROM Names where Name = '$Name' AND `index` !=$iIDs");

variable that may contain apostrophes is :$Name

The values containing the apostrophes are the problem. E.g (O'Leary, O'brien). Those without the apostrophes, I am able to do the search.
Please help. Thanks

here you go buddy
the \" you can use for a double quote inside the double quote argument

__________________________________________________ ________
I am DJ Kat...that's my name. Its a D and a J and a Kat with a K.

Hey, Thanks for the code. But it still doesn't work. I'm thinking its maybe because some of the names in the variable has spaces like ("David O' Leary", "DJ's Station")

I think it should work why not echo your $query1 and try to put the query in manually with phpmyadmin or mysql querybrowser then you will see what the error in your SQL is

__________________________________________________ ________
I am DJ Kat...that's my name. Its a D and a J and a Kat with a K.