To successfully achieve this you need to choose Date Range from within the search wizard
and then specify your fields
Note: my db field will be different to yours as I am using one of my existing sites.
this will give you this code block
php:
<?php
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADAvisitors;
//Searchpage: visitors_Search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) session_start();
if ((isset($_GET["Search_x"]) && $_GET["Search_x"] != "")) {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//keyword array declarations
//comparison list additions
$WADbSearch1->addComparisonFromEdit("VisitorID","S_VisitorID","AND","=",1);
$WADbSearch1->addComparisonFromEdit("VisitorUserName","S_VisitorUserName","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("VisitorPassword","S_VisitorPassword","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("VisitorEmail","S_VisitorEmail","AND","Includes",0);
$WADbSearch1->addComparisonFromList("VisitorDate","S_VisitorDate","AND",">=",2);
$WADbSearch1->addComparison("VisitorDate","".WAQB_getEndDate($_POST["E_VisitorDate"]) ."","AND","<=",2);
$WADbSearch1->addComparisonFromEdit("VisitorFirstName","S_VisitorFirstName","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("VisitorLastName","S_VisitorLastName","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("VisitorBillName","S_VisitorBillName","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("VisitorBillAddress1","S_VisitorBillAddress1","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("VisitorBillAddress2","S_VisitorBillAddress2","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("VisitorBillCity","S_VisitorBillCity","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("VisitorBillStateID","S_VisitorBillStateID","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("VisitorBillCountryID","S_VisitorBillCountryID","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("VisitorBillZip","S_VisitorBillZip","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("userLevel","S_userLevel","AND","=",1);
//save the query in a session variable
if (1 == 1) {
$_SESSION["WADbSearch1_visitors_Results"]=$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_visitors_Results"]) && $_SESSION["WADbSearch1_visitors_Results"] != "") {
$WADbSearch1->whereClause = $_SESSION["WADbSearch1_visitors_Results"];
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
?>
note the addition of the function WAQB_getEndDate to the end date clause.
