[Resolved] Search Box with dropdown (how would i go about doing this?)

qt4u

i have made a search box on my site which i can't figure how i could code it... The drop down box needs to be linked with the textbox is my guess but not too sure how to go about that...

<form action="search.php" method="post" name="Search" id="Search">
<table width="100%" border="0" class="font">
<tr>
<td><div align="center" class="colour0">Search By
<select name="type" class="textbox" id="select">
<option value="Stock">Stock</option>
<option value="Make" selected>Make</option>
<option value="Model">Model</option>
<option value="Year">Year</option>
</select>
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="text" type="text" class="textbox" id="text" size="10">
<input name="Submit" type="submit" class="textbox" value="Submit">
</div></td>
</tr>
</table>
</form>

The idea of the form is this: i would like it so visitors select Stock, Make, Model, Year from the box and type which car they would like to find The Drop Box contains the columns in the table

Hope someone can help me sort this out 😉

cgraz

Try somethign like this

<html>

<head>

<script language="JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}


//-->
</script>

</head>

<body>

<form method="post">

Year:

<?

// connect to your database here

// select your database here

$result2 = mysql_query("SELECT DISTINCT year FROM inventory ORDER BY year") or die(mysql_error());
$row_array = mysql_fetch_row($result2);
echo "<select name='year' onChange=\"MM_jumpMenu('parent',this,0)\">";
echo "<option value="">Select Year</option>";
for ($i=0;$i < mysql_num_rows($result2);$i++)
{
	if ($row_array[0]=="")
	{
		$row_array=mysql_fetch_row($result2);
	}
	else
	{
	echo "<option value='" . $PHP_SELF . "?year=".$row_array[0]."'>".stripslashes($row_array[0])";
	$row_array=mysql_fetch_row($result2);
	}
}
echo "</SELECT>";

?><br><br>

Make: 

<?

$result2 = mysql_query("SELECT DISTINCT make FROM inventory WHERE year='" . $_GET['year'] . "' ORDER BY make") or die(mysql_error());
$row_array = mysql_fetch_row($result2);
echo "<select name='make' onChange=\"MM_jumpMenu('parent',this,0)\">";
echo "<option value="">Select Make</option>";
for ($i=0;$i < mysql_num_rows($result2);$i++)
{
	if ($row_array[0]=="")
	{
		$row_array=mysql_fetch_row($result2);
	}
	else
	{
	echo "<option value='" . $PHP_SELF . "?year=".$_GET['year']."&make=".$row_array[0]."'>".stripslashes($row_array[0])";
	$row_array=mysql_fetch_row($result2);
	}
}
echo "</SELECT>";

?><br><br>

Model:

<?

$result2 = mysql_query("SELECT DISTINCT model FROM inventory WHERE year='" . $_GET['year'] . "' AND make='" . $_GET['make'] . "' ORDER BY model") or die(mysql_error());
$row_array = mysql_fetch_row($result2);
echo "<select name='model' onChange=\"MM_jumpMenu('parent',this,0)\">";
echo "<option value="">Select Model</option>";
for ($i=0;$i < mysql_num_rows($result2);$i++)
{
	if ($row_array[0]=="")
	{
		$row_array=mysql_fetch_row($result2);
	}
	else
	{
	echo "<option value='" . $PHP_SELF . "?year=".$_GET['year']."&make=".$_GET['make']."&model=".$row_array[0]."'>".stripslashes($row_array[0])";
	$row_array=mysql_fetch_row($result2);
	}
}
echo "</SELECT>";

?><br><br>

</form>

</body>

</html>

Code is untested so you may need to workout parse errors etc. When the visitor selects the last item, it will just reload the page with all the variables. You can modify this to do whatever you want with the results.

Cgraz

qt4u

Cheers,
I'll give that a try and if i have any problems i'll reply back again. Thanks for your time, much appreciated.