Recordset for simple search engine in PHP

[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.

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

 

[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