In you articles page replace the search code with the following:
<?php
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADAtblnews;
//Searchpage: tblnews_Search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) session_start();
if ((isset($_GET["Search"]) && $_GET["Search"] != "")) {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//keyword array declarations
//comparison list additions
$WADbSearch1->addComparisonFromEdit("ArticleID","S_ArticleID","AND","=",1);
$WADbSearch1->addComparisonFromEdit("Headline","S_Headline","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("Article","S_Article","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("DatePosted","S_DatePosted","AND","=",2);
//save the query in a session variable
if ((isset($_GET["Search"]) && $_GET["Search"] != "")) { // this line has changed
$_SESSION["WADbSearch1_tblnews_Results"]=$WADbSearch1->whereClause;
}
}
else {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//get the filter definition from a session variable
if ((isset($_GET["Search"]) && $_GET["Search"] != "")) { // this line has changed
if (isset($_SESSION["WADbSearch1_tblnews_Results"]) && $_SESSION["WADbSearch1_tblnews_Results"] != "") {
$WADbSearch1->whereClause = $_SESSION["WADbSearch1_tblnews_Results"];
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
?>
The session variable that holds the search results will now only be triggered when the search button is pressed.