RichardAFCB

Hi there,

I'm trying to create a simple search engine for a client so that customers can search his products. I have one field for text, and another with a drop down list of product types and an "All Items" option.

I've got my recordset to display search results matching the text field and the products, but I can't get it to display All Items if the customer selects that! So basically they can search by product type, but not across all the products.
????: NamePros.com http://www.namepros.com/programming/124994-recordset-for-simple-search-engine-php.html

I'm doing this in Dreamweaver. My actual PHP coding knowledge is...terrible!

Here is my code:

<?php
$colname2_products = "-1";
if (isset($_POST['type'])) {
$colname2_products = (get_magic_quotes_gpc()) ? $_POST['type'] : addslashes($_POST['type']);
}
$colname_products = "-1";
if (isset($_POST['searchterm'])) {
$colname_products = (get_magic_quotes_gpc()) ? $_POST['searchterm'] : addslashes($_POST['searchterm']);
}
mysql_select_db($database_kofightposters, $kofightposters);
$query_products = sprintf("SELECT * FROM products WHERE name LIKE '%%%s%%' AND type = '%s' ORDER BY name ASC ", $colname_products,$colname2_products);
$products = mysql_query($query_products, $kofightposters) or die(mysql_error());
$row_products = mysql_fetch_assoc($products);
$totalRows_products = mysql_num_rows($products);
?>

Any help would be greatly appreciated!

Cheers,

Rich

RichardAFCB

Anybody?

lilgee

All of the stuff is post to be in one field. You didnt post this in the right place

__________________
Sharing 50% profit for helping to sell on ebay. PM me for more info.

RichardAFCB

That makes no sense to me....

RichardAFCB

Anybody?

yz0rx

I'm a little confused. You have a search form with a drop down selection of categories and a search box for keywords? When people search by selecting a category, you want the results from that category only, unless they select the All Items category?

RichardAFCB

Fixed now!

Cheers,

Rich