How get selected category's products in 2nd dropdown ....

[imadnan]

I have 2 tables,

category

------------

catid

catname

Products

----------------

proId

catid

proName

========================================

category:

catId   catname

1          abc

2          xyz

Products:

proId      catdId         proName

1            1                    a

2             1                    b

3             1                    c

4              2                   x

Question:

It is possible I seleect category "ABC"  then second drown down show proname (a',b,c)..

If select category "XYZ" , show it releted product....?

thanks

[Dan_Bracuk]

The concept you are looking for is called related selects.  A google search will show you various ways to accomplish this.  The one I use is described here http://www.pathcom.com/~bracuk/code/RelatedSelects.htm