the error is caused by code order.
lines 55- 95:
<?php require_once("../webassist/database_management/wada_search.php"); ?>
<?php
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: AdminStuff;
//Searchpage: adminsearch.php;
//Form: form1;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) session_start();
if ((isset($_POST["WADbSearch1"])) && ($_POST["WADbSearch1"] != "")) {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//keyword array declarations
$KeyArr0 = array("UserEmail", "UserFirstName", "UserLastName", "UserCity", "UserState", "UserZip", "UserPhone", "UserAddress", "Dealer_ID", "Orderkey", "Jewelry_Type", "Setting_Style");
//comparison list additions
$WADbSearch1->keywordComparison($KeyArr0,"".((isset($_POST["SearchDealers"]))?$_POST["SearchDealers"]:"") ."","AND","Includes",",%20","%20","%22","%22",0);
//save the query in a session variable
if (1 == 1) {
$_SESSION["WADbSearch1_admin"]=$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_admin"]) && $_SESSION["WADbSearch1_admin"] != "") {
$WADbSearch1->whereClause = $_SESSION["WADbSearch1_admin"];
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
?>
should be moved to line 12 so it comes before the recordset.