tjverge

This problem was solved it had nothing to do with the code, was a problem on the server.

I know what it should be doing. I would not be asking for help if it was working right I'm closing this thread as you are not being at all helpful and being kind of on the rude side, I understand you think your helping, but in this case I don't believe you understand the problem. Thank you for trying.

Thought so, so how do I get it to search TJ's insteed of TJ\s I know that if I stripslashes it will give an error

I thought mysql_real_escape_string did escape it

Hello, I have data in an My SQL database that has an apostrophe in it eg: TJ's right now I have the following code $namesearch = mysql_real_escape_string($_POST['name']); $query = "SELECT * FROM pilot WHERE name='$namesearch' "; $result = mysql_query($query) or die(mysql_error()); if (mysql_num_rows($result) ) { include 'show.php'; } else { } It does not come back finding any thing and if I echo $namesearch I get TJ\\\'s How do I get it to search for TJ's rather then TJ\\\'s?