I'm pulling the values for two drop downs from a single sql table based on the ENUM values they can be
so for instance:
dropdown 1:
red
blue
green
dropdown 2:
red_1
red_2
red_3
blue_1
blue_4
blue_36
green_5
green_27
green_100
now, what I'm hoping to accomplish is, when the user picks something from the first drop down, js will remove all the values from the second drop down that don't prefix based on the first
so if the user picks green in the first drop down, the second drop down would only show:
green_5
green_27
green_100
now, im sure some of you (hehe) would say its easier to just ajax out to the db and only grab the records that have that prefix but i'd rather not bust out an entire ajax framework for just one small instance
any help or suggestions would be greatly appreciated.