Trying to Remove ' Apostrophe in Search

Hi everyone, does anyone know how i can get my search on my site to ignore ' apostrophes?

ie.

cat's = cats

i need this cause my db search is case sensitive and its not show search results of products with an ' in it. any help would be great. Thanks again

 

<?
$string = "cat's";
str_replace("'", "", $string);
//$string is now cats
?>

PHP:

 

zerxer will that code work for all apostrophes? I need it to basically omit all apostrophes when people type it in my search box. Thanks again.

 

The code is incorrect.

Correct version:

<?
$string = "cat's";
$string = str_replace("'", "", $string);
//$string is now cats
?>

PHP:

Jay

 

thanks jay. won't this code work just for the word cat's?

 

Yes, but it's just an example.

If you put

$string = $THE_REAL_SEARCH_VARIABLE;

PHP:

Then it will work for whatever is searched.

Jay

 

thanks jay im still learning i'm new to php =] you guys are the best

 

No problem. If you want the code tweaking a bit, just post what your current code looks like and I'm sure I, or someone else, will lend a hand.

Jay

 

Whoops, I forgot to re-set the string, huh. Clumsy. Thanks.