Select boxes

[MitchEvans]

I want to make my selection boxes like the select statements. As a user selects certain things from my drop down boxes I want a certain answer to be returned. This answer is stored in the MySQL database with all the other data. Can anyone point me in the right direction here?

Here's the code for my drop down boxes:

<?php
$db = mysql_select_db("mitch",$connection)
or die ("Couldn't select database");
$query = "SELECT FROM soiltype";
$result = mysql_query($query)
or die ("Couldn't execute query");
while($row = mysql_fetch_array($result)) $soiltype[]=$row;

echo '<SELECT name="dropdown">';

foreach ($soiltype as $s)

echo "<OPTION>{$s['Soiltype']}</OPTION>\n";
echo '</SELECT>';
?>
<?php
$db = mysql_select_db("mitch",$connection)
or die ("Couldn't select database");
$query1 = "SELECT FROM product";
$result1 = mysql_query($query1)
or die ("Couldn't execute query");
while($row1 = mysql_fetch_array($result1)) $surface[]=$row1;

echo '<SELECT name="dropdown">';

foreach ($surface as $su)

echo "<OPTION>{$su['surface']}</OPTION>";

echo '</SELECT>';
?>
<?php
$db = mysql_select_db("mitch",$connection)
or die ("Couldn't select database");
$query2 = "SELECT * FROM product";
$result2 = mysql_query($query2)
or die ("Couldn't execute query");
while($row2 = mysql_fetch_array($result2)) $soillevel[]=$row2;

echo '<SELECT name="dropdown">';

foreach ($soillevel as $so)

echo "<OPTION>{$so['soillevel']}</OPTION>";

echo '</SELECT>';
?>

[groovepapa]

Not quite sure what you're trying to do...can you clarify a bit?

The code for the select boxes looks ok. If you want answers to come back as a result of changing the select box, you can use javascript's onChange event-handler on the select boxes to submit a form, or kick off an ajax request...i.e.,

<select name="soiltype" onChange="javascript:answerSoilType();">

Is that what you're asking about?

[MitchEvans]

Well when my users select from these drop down boxes and click submit, I want a product to appear depending on what the boxes say. This product is held in the MySQL database with all the other information. Example user chooses Oil, Carpet, and medium, the answer should then be the correct product held on the database.

[groovepapa]

Assumming your database is structured and loaded with the proper attribute values tied to the proper products...i.e.,

table: product
product_id, soil_type, surface, soil_level
'a', 'oil', 'carpet', 'medium'

You can simply write a .php page to select from the table and display the results, like this page describes.

Is this your first venture with PHP? If so, you should probably check out the 'Newbies' forum.