Can anyone provide code snippets for cascading dropdowns (2 off) so that when item e.g. Fruit is selected in the first dropdown, the items e.g. Bananas, Apples appear in the second dropdown without the page refreshing. I'd be eternally greatful as i've been stuck on this for weeks, Thanks Mark

You need a javascript that is triggered when the first dropdown changes; when triggered it uses the changed value to access a database and populate the second dropdown.

If you're going to get into this kind of coding check out jquery, it will make you life a lot easier but the learning of it might make your head spin at first []

Here's an example

A great place for help is stackoverflow too

and don't forget that google is your friend