ok well I was hoping for a more generic solution :)
actually re-reading what my original post stated...I was asking for something generic originally, in this case if you read what I originally said:
"what I would like to do is the search box checks for the value to "contain".....for example a customer enters into the search box: ARMCHAIR"
im ny oriignal above statement, I did say "for example a customer enters..." So I assumed it was obvious want I wanted was generic (just saying) :)
Slight issue, you told me to change the = to LIKE in my recordset...however the recordset in use is a straight "SELECT * FROM products so there is no place to put the LIKE clause.
here is the complete recordset (its using a case statement and the search by product name is at the bottom of this code block)
case "Search":
$rsProducts = new WA_MySQLi_RS("rsProducts",$ecartdb,0);
$rsProducts->setQuery("SELECT * FROM products");
if (isset($_GET["Price"])) {
$prices = explode(":",$_GET["Price"]);
$rsProducts->addFilter("ProductPrice",">=","d",$prices[0]);
$rsProducts->addFilter("ProductPrice","<=","d",$prices[1]);
}
$productTypes = array();
if (isset($_GET["Wood"])) {
$productTypes[] = "Wood";
}
if (isset($_GET["Metal"])) {
$productTypes[] = "Metal";
}
if (isset($_GET["Glass"])) {
$productTypes[] = "Glass";
}
if (sizeof($productTypes) > 0) $rsProducts->addFilter("ProductType","=","s",$productTypes);
if (isset($_GET["Product"])) {
$productName = $_GET["Product"];
$rsProducts->addFilter("ProductName","=","s",$productName);
}
$rsProducts->setFilter();
$rsProducts->execute();
break;
Chris