PHP4 Mysql Java Menus = Fried Brain

Anon

K, ill explain this the best i can =O!

Ive a mysql database with several tables
3 of these tables are called manufacturer, model, variant.
Ive succesfuly got to the stage where the data is all ready i can pull/push data from the database no problem, create dropdown menus from the date using arrays etc. great - Problem is i want the second pulldown menu populated by the results of the first pulldown and the third pull down to be populated by the results of the second pulldown menu etc etc,
Looked all over for code found some php4+mysql menus and java menus and tried to fuse the two to no avail
Is there a tutorial or help anywhere on this - im sure its a common problem.

Anon

oh heres me code works fine tho no relations

<HEAD>
<TITLE>Sample Form</TITLE>
</HEAD>
<BODY>

// create connection
$connection = mysql_connect("localhost","root","")
or die("Couldn't make connection.");

// select database
$db = mysql_select_db("dealsheet", $connection)
or die("Couldn't select database.");

// create SQL statement
$sql = "SELECT model FROM model
ORDER BY model ASC";

// execute SQL query and get result
$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute query.");

// put data into drop-down list box
while ($row = mysql_fetch_array($sql_result)) {

$model  = $row["model"];
$models .= "<OPTION value=\"$model\">$model</OPTION>";

}

// create SQL statement
$sql = "SELECT variant FROM variants
ORDER BY variant ASC";

// execute SQL query and get result
$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute query.");

// put data into drop-down list box
while ($row = mysql_fetch_array($sql_result)) {

$variant  = $row["variant"];
$variants .= "<OPTION value=\"$variant\">$variant</OPTION>";

}

// create SQL statement
$sql = "SELECT man FROM manufact
ORDER BY man ASC";

// execute SQL query and get result
$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute query.");

// put data into drop-down list box
while ($row = mysql_fetch_array($sql_result)) {

$man  = $row["man"];
$mans .= "<OPTION value=\"$man\">$man</OPTION> ";

}

<P>Manufacturer:
<SELECT name="Manufacturer">

<? echo "$mans"; ?><? echo "$fran"; ?>

</SELECT>

Model:
<SELECT name="model">

<? echo "$models"; ?>

</SELECT>

Variant:
<SELECT name="variant">

<? echo "$variants"; ?>

</SELECT>

</FORM>

</BODY>