[SOLVED] Searching for names?

[marcb]

Hi, I'm having trouble searching my d/b using a person's name when the name includes a '.

 

For example, if I want to run this query:

 

SELECT * FROM people WHERE surname='O'Neal';

 

This has a bit of a fit as it thinks the ' in O'Neal is the end of the search criteria and then doesn't know what to do with the Neal bit.

 

Am I being a noob?

[Barand]

www.php.net/addslashes()

 

$search = "O'Neal";

 

$search = addslashes($search);        //--> O\'Neal

 

SELECT * FROM people WHERE surname='$search'

 

[marcb]

Lovely, thanks, that makes life easier.

 

Thanks again.