Just found this simple but effective javascript code, utilising the invaluable jquery library to create linked select lists. You select the first list and it magically goes off and generates the options in the 2nd and 3rd lists. This in itself isn’t anything particularly ground breaking, but this code connects to the database on-demand, then generates the menu options via a JSON response. I’ve just downloaded the code and at first glance it looks very tidy.

I’m not sure where I’ll manage to build this into a site just yet, but it’s nice to know if I ever do need it, there is a solution out there.
Maybe it could be used on registration forms where you want people to specify where they live… Getting the data itself could be tricky. Or maybe selecting categories/sub categories for a search. If only they had UK counties and cities in the attached db file too, now that would be handy! 🙂

Anyway here’s the code