Select Box help (With AJAX support)

[nepal12]

Hi guys,

I need an urgent help from you profi .

 

Take a look at this:

 

<select name="cat">

                    <option id="opt1">Movie</option>

                    <option id="opt2">Music</option>

                    <option id="opt3">Television</option>

                   

</select>

 

<select name="sub_cat">

                    <option id="s_opt1">Action </option>

                    <option id="s_opt2">Adventure</option>

                    <option id="s_opt3">Thriller</option>

                   

</select>

 

The situation is so,

 

I select movie in first select option , then it should store a variable $catagory and i could be able to search the database to populate the options in second select. That is , the selection of the first one should store a variable which when check in the database can list the subcatagory with the catagory selected, in above case, when movie as cat is selected then the subcat should contain the options with category movie.

 

Thanks in advance