[jomama13]

I need help populating a list box called 'SubCategory' with results from a db query. The list box should only have results that apply to the first select box called 'Category'. In short this is how I would like to do it but I don't have the technical prowess to complete the JavaScript programming part of it.


//DB QUERY 1 for Categories to populate select box named 'Category'

//DB QUERY 2 for SubCategories to later populate the JavaScript array below to be accessed later by a function in an onChange (or equivalent) JavaScript call attached to the first select box(Category).


=>NEED HELP HERE<=
//JavaScript array with values from DB Query 2(fields: CategoryID, SubCategoryID, SubCatDesc)
//JavaScript function
=>NEED HELP, DON'T KNOW HOW TO DO IT<=

//FIRST SELECT BOX
<select name="Category" onChange="javascript:UpdateSubCat(this.value);">
<option selected>Select One</option>
<?php
$i=1; //initliaze a counter
while ($rows=mysql_fetch_array($result1)){

//assign the data to some variables - not really needed but clearer when coding
$catid= $rows['CategoryID']; $catdesc=$rows['CategoryDesc'];

echo "<option value=" . $catid . >" . $catdesc . "</option>";
$i++; //increment the counter

} //close the while loop

?>
</select>
//END SELECT #1

<select name="SubCategory">
//DON"T KNOW HOW TO POPULATE THIS
</select>


Please help in any way possible. I know there are many ways to do this but this is the way I want to approach it.

Thanks in advance for all of your help

Joe