DA Search unknown column in where clause error
I have an issue with the following code returning the error Unknown column 'fkTitle' in 'where clause'
Search Parameters
//keyword array declarations
$KeyArr0 = array("view.title");
$KeyArr1 = array("view.image");
$KeyArr2 = array("view.details");
$KeyArr3 = array("fkTitle");
$KeyArr4 = array("view.title");
$KeyArr5 = array("view.details");
//comparison list additions
$WADbSearch1->keywordComparison($KeyArr0,"".((isset($_GET["zoom_query"]))?$_GET["zoom_query"]:"") ."","OR","Includes",",%20","%20","%22","%22",0);
$WADbSearch1->keywordComparison($KeyArr1,"".((isset($_GET["zoom_query"]))?$_GET["zoom_query"]:"") ."","OR","Includes",",%20","%20","%22","%22",0);
$WADbSearch1->keywordComparison($KeyArr2,"".((isset($_GET["zoom_query"]))?$_GET["zoom_query"]:"") ."","OR","Includes",",%20","%20","%22","%22",0);
$WADbSearch1->keywordComparison($KeyArr3,"".((isset($_GET["zoom_query"]))?$_GET["zoom_query"]:"") ."","OR","Includes",",%20","%20","%22","%22",0);
$WADbSearch1->keywordComparison($KeyArr4,"".((isset($_GET["S_title"]))?$_GET["S_title"]:"") ."","AND","Includes",",%20","%20","%22","%22",0);
$WADbSearch1->keywordComparison($KeyArr5,"".((isset($_GET["S_details"]))?$_GET["S_details"]:"") ."","AND","Includes",",%20","%20","%22","%22",0);
$WADbSearch1->addComparisonFromEdit("view.sortorder","S_sortorder","AND","=",1);
$WADbSearch1->addComparisonFromEdit("view.archive","S_archive","AND","=",1);
$WADbSearch1->addComparisonFromEdit("view.dateinsert","S_dateinsert","AND","=",2);
$WADbSearch1->addComparisonFromEdit("view.dateupdate","S_dateupdate","AND","=",2);
$WADbSearch1->addComparisonFromEdit("view.fk","S_fk","AND","=",1);
SQL Statement
SELECT fk.id AS fkid, fk.title AS fkTitle, view.title AS title, view.details AS details, view.image AS image, view.sortorder AS sortorder, view.archive AS archive, view.dateinsert AS dateinsert, view.dateupdate AS dateupdate, FROM_UNIXTIME(view.tstampinsert,'%M %D, %Y') AS tstampinsert, FROM_UNIXTIME(view.tstampupdate,'%M %D, %Y') AS tstampupdate, view.fk AS fk, view.id AS id FROM tbl_subcategories AS view JOIN tbl_categories AS fk ON (view.fk = fk.id) ORDER BY view.sortorder DESC, view.dateinsert DESC, view.title
As you can see fkTitle is clearly defined so what is going wrong ?
Thanks,