Apostrophe in keyword search

I am having some issues with a DataAssist form i have created. For example, when i enter a keyword with an apostrophy in it eg: Mick's, no results show up, however if i search for Mick the results are displayed and one of the results is Mick's?

//keyword array declarations
$KeyArr1 = array("category", "business");
$KeyArr2 = array("suburb", "postcode");

//comparison list additions
$WADbSearch1->keywordComparison($KeyArr1,"".((isset($_POST["what"]))?$_POST["what"]:"") ."","OR","Includes","AND",",%20","%22","%22",0);
$WADbSearch1->keywordComparison($KeyArr2,"".((isset($_POST["area"]))?$_POST["area"]:"") ."","AND","=","%20AND%20",",%20","%22","%22",0);

could be that GPC Magic Quotes is enabled on the server, so Mike's is being converted to Mike\'s

try changing:

//comparison list additions

$WADbSearch1->keywordComparison($KeyArr1,"".((isset($_POST["what"]))?$_POST["what"]:"") ."","OR","Includes","AND",",%20","%22","%22",0) ;

$WADbSearch1->keywordComparison($KeyArr2,"".((isset($_POST["area"]))?$_POST["area"]:"") ."","AND","=","%20AND%20",",%20","%22","%22",0) ;

to:

//comparison list additions

$WADbSearch1->keywordComparison($KeyArr1,"".((isset($_POST["what"]))?stripslashes($_POST["what"]):"") ."","OR","Includes","AND",",%20","%22","%22",0) ;

$WADbSearch1->keywordComparison($KeyArr2,"".((isset($_POST["area"]))?stripslashes($_POST["area"]):"") ."","AND","=","%20AND%20",",%20","%22","%22",0) ;

OK tried that, made no difference. The strange thing is if i search for Mick the results page shows the results but the apostrophe is a black diamond. If i refresh the results page (in Firefox), the diamonds then display correctly as apostrophes.

Hmmmm.....just checked Internet Explorer and the apostrophes show as boxes on the results page and don't change when i refresh the page.


Checked the database and the records look correct, the doctype is:
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />

Also database collation set to latin1_swedish_ci

After applying your code i am now getting a popup message when i try and enter the DA Search Server Behaviour, see attached.

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.