how to querie multiple selection boxes

[zayin7232]

Hello everyone. I am in desperate need of what will probably turn out to be a very simple and dumb question!
But... I need two or three selection boxes that will query at onece instead of having to hit search after each selection is chosen.
I can get eacch selection box to query seperately but I can not seem to get it to work puting both queries on the same file. Am I making any sense at all?? Anyway here it is..

My 1st selection box

$query = "SELECT DISTINCT vehicle_Make FROM Engines ORDER BY vehicle_Make";
$result = mysql_query($query)
or die ("Couldn't execute query.");

/ create form containing selection list /
echo "<center><form action='processform.php' method='post'></center>
<center><select name='vehicle_Make'></center>\n";

while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<center><option value='$vehicle_Make'>$vehicle_Make \n";
}
echo "</select>\n";
echo "<input type='submit' value='Search'>
</form>\n";
?>
</body>
</html>

My 2nd selection box

$query = "SELECT DISTINCT engine_Cid FROM Engines ORDER BY engine_Cid";
$result = mysql_query($query)
or die ("Couldn't execute query.");

/ create form containing selection list /
echo "<form action='processform2.php' method='post'>
<select name='engine_Cid',>\n";

while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<option value='$engine_Cid'>$engine_Cid\n";
}

echo "</select>\n";
echo "<input type='submit' value='Search'>
</form>\n";
?>
</body>
</html>

Processform for 1st selection box

$query = "SELECT * FROM Engines WHERE vehicle_Make='$vehicle_Make'";
$result = mysql_query($query)
or die ("Couldn't execute query.");

/* Display results in a table */

echo "<center><h1>Engine Price List</h1></center>";
echo "<center><h1>$vehicle_Make</h1></center>";
echo "<table cellspacing='15'>";
echo "<tr><td colspan='60'><hr></td></tr>";
while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<tr>\n
<td>$engine_Cid</td>\n
<td>$engine_Cyl</td>\n
<td>$engine_startYear</td>\n
<td>$engine_endYear</td>\n
<td>$engine_Liters</td>\n
<td>$engine_Specs</td>\n
<td>$engine_lbprice</td>\n
<td>$engine_lbcore</td>\n
</tr>\n";
echo "<tr><td colspan='15'><hr></td></tr>\n";
}
echo "</table>\n";
?>
</body>
</html>

Processform for 2nd selection box

$query = "SELECT * FROM Engines WHERE engine_Cid='$engine_Cid'";
$result = mysql_query($query)
or die ("Couldn't execute query.");

/ Display results in a table /
echo "<h1>Engine Price List</h1>";
echo "<table cellspacing='15'>";
echo "<tr><td colspan='60'><hr></td></tr>";
while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<tr>\n
<td>$engine_Cid</td>\n
<td>$engine_Cyl</td>\n
<td>$engine_startYear</td>\n
<td>$engine_endYear</td>\n
<td>$engine_Liters</td>\n
<td>$engine_Specs</td>\n
<td>$engine_lbprice</td>\n
<td>$engine_lbcore</td>\n
</tr>\n";
echo "<tr><td colspan='15'><hr></td></tr>\n";
}
echo "</table>\n";
?>
</body>
</html>

Thanks in advance for anyone who has a moment to help me out I appreciate it more than you know.

[pete_bisby]

Firstly, name your forms - it will make it less confusing.

Then place the onChange event within your select statements, so:

<select name="vehicle_Make" onChange="Form1.submit()">

Now each time a selection is made, your form will be submitted automatically.

[zayin7232]

Okay I did not know how to do the submit autmatically thing shown above so I am glad and greatful for that piece of advice but how do I put both query 1 and query 2 on the same page or together. I am very new at this so I need it broke down into lamens terms if I could please!

Thanks again in advance

[pete_bisby]

Place both drop-down boxes within the same form, then before submitting the information check that both drop-down boxes have been completed. A little bit of JavaScript would probably be in order here.

Have a single button to submit your details - remove the onChange events from the drop-down boxes.

<input type="button" name="Submit" onClick="check_details()">

Now for the JavaScript ....

function check_details() {
  if ((this.form.dropdown1.value=="") || (this.form.dropdown2.value=="")) {
    window.alert("Both drop-down boxes must be completed");
    return;
  } else {
    this.form.submit();
  }
}

Now combine your final queries together ....

$query = "SELECT * FROM Engines WHERE engine_Cid='$engine_Cid' AND vehicle_Make='$vehicle_Make'";

... and produce your results.

Hope this helps!