Populating a dropdown field based on the value of another field

[everknown]

I'm using MySQL and PHP and I have a form with two dropdowns, one for food item, and another for units.

The user should select the food item, and the form should go fetch the unit options from the database on the server for that food item.

I imagine I need to use Javascript to open a PHP page that just returns the options and use the javascript to populate the field options.

Is Javascript the best way to do this? Is there any solution that would not require me to use Javascript?

Does anyone have a link to an example I coudl crib from? Much thanks!!!

[Roger_Ramjet]

This one comes up a lot. JAVA is the best solution because:

1. it is processed Client-side as the user selects one, the other changes instantly
2. there are loads of scripts around to save you writing your own. See http://javascript.internet.com/forms/ for what you need, and bookmark http://javascript.internet.com/ for your future java needs.

[[deleted]]

I did something like this once with Javascript. It actually isn't that big of a deal. Of course I don't work for that company anymore, so I don't have the code handy. http://tinyurl.com/4rdws might help you though.