Parts Search

[isabellek]

I was wondering how I could go about learning how to code something that would allow for a menu search like this one using PHP:

http://www.knfilterchargers.com/search/appsearch.aspx

it allows one to pick a year, then the make, then the model, then the engine size and finally displays results.

I am new, so still somewhat shaky on PHP/Database stuff. Thanks.

[jannoy]

well in your example

here is a simple query
let us take a sample of two forms

consider your method is a POST then we use $POST or when use GET we use $GET
like :
$year=$GET['year'];
$model=$GET['model'];

and in your queries
$query=mysql_query("select * from yourtable where year='$year' and model like '%$model%' ");

then let us grab the result of
(while $result=mysql_fetch_object($query) ) {

echo $result->nameofyourfield; /// display result
echo "<br>";
}

[Roger_Ramjet]

Interesting problem, while I wait for my backup to finish:

The page you linked uses a lot of javascript to achieve its results. In php we could do something like this

<form name="selector" action="<?=$_SERVER['PHP_SELF']?> "  method="post">

<?
//--- CHECK FOR PREVIOUS SELECTIONS
if (isset($_POST['combo1'])) { $var1 = $_POST['combo1'];} else { $var1 = ""}
if (isset($_POST['combo2'])) { $var2 = $_POST['combo2'] } else { $var2 = ""}

//--- CREATE COMBO 1 ---
$sql = "SELECT DISTINCT field1 FROM table ORDER BY field1";
$result = mysql_query($sql) or die($sql . '<br />' . mysql_error());
echo '<select name="combo1" onchange=submit()>';
while ($row = mysql_fetch_array($result)) {
	//preserve selection from page to page
	if( $row['field1'] == $var1) { 
		echo '<option value="' . $row['field1'] . '" selected="selected">' . $row['field1'] . '</option>';
	}
	else {
		echo '<option value="' . $row['field1'] . '">' . $row['field1'] . '</option>';
	}
}
	echo '</select>';
//--- END CREATE ---

//--- CREATE COMBO 2 --- only if first selection has been made
if (isset($_POST['combo1'])) {
	$sql = "SELECT DISTINCT field2 FROM table WHERE field1 = '$var1' ORDER BY field2";
	$result = mysql_query($sql) or die($sql . '<br />' . mysql_error());
	echo '<select name="combo2" onchange=submit()>';
	while ($row = mysql_fetch_array($result)) {
		//preserve selection from page to page
		if( $row['field2'] == $var2) { 
			echo '<option value="' . $row['field2'] . '" selected="selected">' . $row['field2'] . '</option>';
		}
		else {
			echo '<option value="' . $row['field2'] . '">' . $row['field2'] . '</option>';
		}
	}
	echo '</select>';
}
//--- END CREATE ---

//and so on for each category
?>