Hi Dave
Many thanks for replying.
I'm using 'GET' so that the SiteID and lang parameters are captured.
Unfortunately, I'm not making any progress. All pages belonging to the SiteID are returned - at least it's not returning others'!
The form code:
<form action="search_results2.php" method="get" name="WADASearchForm" id="WADASearchForm">
<div class="WADAHorizLine"></div>
<table class="WADADataTable" cellpadding="0" cellspacing="0" border="0">
<tr>
<th class="WADADataTableHeader"><span class="WADADataNavButtonCell">
<input name="SiteID" type="hidden" id="SiteID" value="<?php echo $_GET['SiteID']; ?>" />
<input name="lang" type="hidden" id="lang" value="<?php echo $_GET['lang']; ?>" />
</span>Page Title:</th>
<td class="WADADataTableCell"><input type="text" name="searchtext" id="searchtext" value="" size="32" /></td>
</tr>
</table>
<div class="WADAHorizLine"></div>
<div class="WADAButtonRow">
<table class="WADADataNavButtons" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="WADADataNavButtonCell" nowrap="nowrap"><input type="image" name="Search" id="Search" value="Search" alt="Search" src="WA_DataAssist/images/Pacifica/Refined_search.gif" /></td>
</tr>
</table>
</div>
</form>
----------------------
And I have copied your code to use the one field;
<?php
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADApages;
//Searchpage: pages_Search.php;
//Form: WADASearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) session_start();
if ((isset($_GET["WADbSearch1"])) && ($_GET["WADbSearch1"] != "")) {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//keyword array declarations
$KeyArr0 = array("PgTitle");
$KeyArr1 = array("PgDesc");
$KeyArr2 = array("PgDetails");
//comparison list additions
$WADbSearch1->keywordComparison($KeyArr0,"".((isset($_GET["searchtext"]))?$_GET["searchtext"]:"") ."","AND","Includes",",%20","%20","%22","%22",0);
$WADbSearch1->keywordComparison($KeyArr1,"".((isset($_GET["searchtext"]))?$_GET["searchtext"]:"") ."","OR","Includes",",%20","%20","%22","%22",0);
$WADbSearch1->keywordComparison($KeyArr2,"".((isset($_GET["searchtext"]))?$_GET["searchtext"]:"") ."","OR","Includes",",%20","%20","%22","%22",0);
//save the query in a session variable
if (1 == 1) {
$_SESSION["WADbSearch1_search_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_pages_Results"]) && $_SESSION["WADbSearch1_search_results"] != "") {
$WADbSearch1->whereClause = $_SESSION["WADbSearch1_search_results"];
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
?>
----------------------
Thanks again,
Chris
