Change subcategories values...

[pavmoxo]

I have 2 dropdown that I have to associate:


This is the category dropdown:

<select name="cat_ID" id="cat_ID" tabindex="3">
<?
$sql = "select cat_ID, cat_nome from cat_links order by cat_nome" ;
$query = query($sql);
$conta = mysql_num_rows($query);
for ($i=0;$i<$conta;$i++)
{
$arrl = mysql_fetch_array($query);
?>

<option value="<?php echo $arrl["cat_ID"]; ?>"><?php echo $arrl["cat_nome"]; ?></option>
<? } ?>

</select>

And this is the subcategory dropdown:

<select name="subcat_ID" id="subcat_ID" tabindex="3">
<?
$sql = "select s.subcat_ID, s.subcat_nome from subcat_links s, cat_links c where c.cat_ID = ".$arrl["cat_ID"]." order by s.subcat_nome" ;
$query = query($sql);
$conta = mysql_num_rows($query);
for ($i=0;$i<$conta;$i++)
{
$arrl = mysql_fetch_array($query);
?>

<option value="<?php echo $arrl["subcat_ID"]; ?>"><?php echo $arrl["subcat_nome"]; ?></option>
<? } ?>

</select>


What I want is when in choose a category, the subcategories will change to correpond. Can you help me??

[pavmoxo]

Do you have any ideia for resolve this case?? Do you have a script example for this for correspond Categories and subCategories that are in a mySql DB??
I really need your help!!!....