Skip to main content
I
imadnan
Participant
September 17, 2010
Question

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

  • September 17, 2010
  • 1 reply
  • 356 views

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

    This topic has been closed for replies.

    1 reply

    D
    Dan_Bracuk
    Inspiring
    September 17, 2010

    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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices