Why my County OR fields only work if one is selected?
I setup a search, that everything works except the County, when more than 1 is selected. If you select no county (checkbox) or just one of the counties (checkbox) it works great, but if you select 2 or more of the 3 checkbox's, then the results are wrong.
Here is what I have for the coding.
$WADbSearch2_DefaultWhere = "";
if (!session_id()) session_start();
if ((isset($_GET["WADbSearch2"])) && ($_GET["WADbSearch2"] != "")) {
$WADbSearch2 = new FilterDef;
$WADbSearch2->initializeQueryBuilder("MYSQL","1");
//keyword array declarations
//comparison list additions
$WADbSearch2->addComparisonFromList("County","countyname","OR","=",0);
$WADbSearch2->addComparisonFromList("County","countyname2","OR","=",0);
$WADbSearch2->addComparisonFromList("County","countyname3","OR","=",0);
$WADbSearch2->addComparisonFromList("BodyOfWater","LakeAnna","AND","=",0);
$WADbSearch2->addComparisonFromList("WaterFront","waterOrientation_WF","AND","=",0);
$WADbSearch2->addComparisonFromList("WaterAccess","waterOrientation_WA","AND","=",0);
$WADbSearch2->addComparisonFromList("WaterView","waterOrientation_VW","AND","=",0);
$WADbSearch2->addComparisonFromEdit("ListPrice","minPrice","AND",">=",1);
$WADbSearch2->addComparisonFromEdit("ListPrice","maxPrice","AND","<=",1);
$WADbSearch2->addComparisonFromEdit("Bedrooms","minBeds","AND",">=",1);
$WADbSearch2->addComparisonFromEdit("Bedrooms","maxBeds","AND","<=",1);
$WADbSearch2->addComparisonFromEdit("BathsFull","minBath","AND",">=",1);
$WADbSearch2->addComparisonFromEdit("BathsFull","maxBath","AND","<=",1);
$WADbSearch2->addComparisonFromCheck("Docks","dock","1","","AND",">=","<>",1);
$WADbSearch2->addComparisonFromCheck("BasementY_N","basement","True","","AND","=","=",0);
$WADbSearch2->addComparisonFromEdit("TotalSquareFootage","minSQFT","AND",">=",1);
$WADbSearch2->addComparisonFromEdit("TotalSquareFootage","maxSQFT","AND","<=",1);
$WADbSearch2->addComparisonFromEdit("Garage_Spaces","garage_min","AND",">=",1);
$WADbSearch2->addComparisonFromEdit("Garage_Spaces","garage_max","AND","<=",1);
$WADbSearch2->addComparisonFromEdit("Levels","levels_min","AND",">=",1);
$WADbSearch2->addComparisonFromEdit("Levels","levels_max","AND","<=",1);
What am I missing?