Hi Eric, Actually, the search behavior is returning too MANY results. (Plus, at this point we only have 2 dummy records) What is happening is that when a person searches for a doctor who treats, say Anxiety, in Adults... the Search Assist returns doctors who treat anxiety (good) in children (bad). But even that is enough to have a not-specific result set returns. Code block for DataSearch is below.
1st param = Interests
2nd param = ages served
we want BOTH to be true in order to be included, not just one.
-------
<?php
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: rsPractice1;
//Searchpage: ;
//Form: ;
$WADbSearch1_DefaultWhere = "SELECT * FROM Vmempublic";
if (!session_id()) session_start();
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//keyword array declarations
$KeyArr1 = array("INTERESTS");
$KeyArr2 = array("ages_served");
//comparison list additions
$WADbSearch1->keywordComparison($KeyArr1,"".((isset($_POST["INTERESTS"]))?$_POST["INTERESTS"]:"") ."","AND","Includes","%20AND%20","%20OR%20","%22","%22",0);
$WADbSearch1->keywordComparison($KeyArr2,"".((isset($_POST["ages_served"]))?$_POST["ages_served"]:"") ."","AND","Includes",",%20","%20","%22","%22",0);
//save the query in a session variable
if (1 == 1) {
$_SESSION["WADbSearch1_search_matrix_v3_INT"]=$WADbSearch1->whereClause;
}
}
else {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//get the filter definition from a session variable
if (1 == 1) {
if (isset($_SESSION["WADbSearch1_search_matrix_v3_INT"]) && $_SESSION["WADbSearch1_search_matrix_v3_INT"] != "") {
$WADbSearch1->whereClause = $_SESSION["WADbSearch1_search_matrix_v3_INT"];
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
?>
