Search Engine

[Anon]

I am looking for a example of a PHP search engine that will search 3 varibles. (ie category, price, item number.) If you have something that might fit what I am looking for email me or contact me at ICQ # 65617065.
thanks

[Anon]

are you searching in a database?

[Anon]

Yes I am searching out of a MySql database.

[Anon]

on the first page you need a form to submit

//form.html
<form action="search.php" METHOD="post">
<INPUT TYPE="text" NAME="category">
<INPUT TYPE="text" NAME="price">
<INPUT TYPE="text" NAME="itemnum">
<!--- any of those could have been SELECT popups instead of text inputs -->
<INPUT TYPE="submit" VALUE="search">
</form>

// other page, search.php
<!--- pretty formatting goes here -->
<?
$query = "SELECT * FROM mytable WHERE ";
$query .= " category_column = '$category';
if ($price)
$query .= " AND price_column = '$price';
if ($itemnum)
$query .= " AND itemnum = '$itemnum';

// connect to mysql database here using mysql_connect and mysql_select_db.. insert the cod ehere

$result = mysql_query($query);
while ($thisrow = mysql_fetch_row($result)) {
//echo each of the values from the select here in a nice formatted table
}

--harlan

?>