Zend framework, mysql and jquery dynamic select boxes
I want to be able to change the value of the second select box based on the input in the fist select box.
As an example, if a person selects USA from the first select box they should only be able to choose from 'napa' or 'paso robles' in the second select box. If they click on France in the first select box they should only be allowed to choose from 'Bordeaux' or 'Provance' in the second select box.
Both select boxes are loaded from a mysql database, adding another layer of neck pain to the equation. I think this will require something like jquery and I'm just not any good at that.