Search feature not working on web site

On this page, advSearch.php, the search feature is not working as expected. I am using AND parameters with my criteria, but it's not returning correct results. it will recognize what's in the category or state fields, but will not recognize the keywords field and returns all results. I am including three separate fields in the db table for the keywords field - not sure if that makes a difference or not. Thank you!

send a copy of the page please so i can see the code.

Attached is a zip file containing the search and results pages.

on the results page, change:

$WADbSearch1->keywordComparison($KeyArr1,"".((isset($_POST["S_keywords"]))?$_POST["S_keywords"]:"")  ."","AND","=","%20AND%20","%20OR%20","%22","%22",0);

to:

$WADbSearch1->keywordComparison($KeyArr1,"".((isset($_GET["S_keywords"]))?$_GET["S_keywords"]:"")  ."","AND","=","%20AND%20","%20OR%20","%22","%22",0);

Sorry, Jason. That didn't work. Still came back with nothing when I enter a search word into the keywords field.

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

Jason ... now my simple, keyword search isn't working. It's returing all results, no matter what I enter in the field.

placesofinterestusa.dataride-previews.com

It's the search form that's in the page header.

This is my code:

<?php
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: getListings;
//Searchpage: simple_search.php;
//Form: SearchForm;
$WADbSearch1_DefaultWhere = "";
if (!session_id()) session_start();
if ((isset($_POST["WADbSearch1"])) && ($_POST["WADbSearch1"] != "")) {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//keyword array declarations
$KeyArr1 = array("listingName", "summary", "keywords");

//comparison list additions
$WADbSearch1->keywordComparison($KeyArr1,"".((isset($_GET["S_keywords"]))?$_GET["S_keywords"]:"") ."","AND","Includes","%20AND%20","%20OR%20","%22","%22",0);

//save the query in a session variable
if (1 == 1) {
$_SESSION["WADbSearch1_simple_search"]=$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_simple_search"]) && $_SESSION["WADbSearch1_simple_search"] != "") {
$WADbSearch1->whereClause = $_SESSION["WADbSearch1_simple_search"];
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
?>

Thank you!!!

cheange the method of the search form from POST to GET

Jason, I'm still getting the same results, even after changing the action to GET.

send a copy of the results.php page please.