thanks pyfsapple!!!!!
i've try using javascript but i'm not that familiar with javascript.
i've finisht some of the coding and i'm only be able to call the first combobox..... this is my code
<html>
<body>
<form name="form1" action="/cgi-bin/redirect.cgi">
<?
$db_name = "resource_base";
$connection = @mysql_connect("localhost") or die("couldn't connect");
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select db");
$sql = "select distinct classify_CAT from classification";
$sql2 = "select count(classify_CAT) from classification";
$result = @mysql_query($sql, $connection) or die("mysql query bombed");
$result2 = @mysql_query($sql2, $connection) or die("mysql query bombed");
$g=mysql_fetch_array($result2);
echo "<select name='arts' width=1 size=1 onChange = 'form2.output.value = form1.arts.value' >";
for($i=1; $i<=7; $i++)
{
$row = mysql_fetch_array($result);
$classify_CAT = $row['classify_CAT'];
echo "<option value=$classify_CAT>";
echo"$classify_CAT";
}
echo "</select>";
?>
</form>
<form name="form2" action="/cgi-bin/redirect.cgi">
<input type = "text" name = "output" size="15">
<select name=arts>
<?
$value = output.value;
$db_name = "resource_base";
$connection = @mysql_connect("localhost") or die("couldn't connect");
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select db");
$sql = "select distinct classify_subject from classification where classify_CAT = '$value'";
$result = @mysql_query($sql, $connection) or die("mysql query bombed");
while ($row = mysql_fetch_array($result)) {
$classify_subject = $row['classify_subject'];
print ("<option>$classify_subject</option>");
} // end while
?>
</select>
</form>
</body>
</html>
