Another way to get dependent dropdowns?

I need a way to enter country, province, city data in an entry form (CCK). Usually you see this on websites as three drop down boxes. First select the country from the 1st drop down list, and it gets entered in the form, then the 2nd drop down box shows the provinces for the selected country, and finally the 3rd shows the cities for the selected province. All three get entered into the form. Some people call these dependent drop downs. The listings of the countries, provinces, and cities are all stored in taxonomy. I don't necessarily have to store the data in taxonomy, but it just seemed appropriate, especially since my end user will want to add to it from time to time and it's got to be dumbass simple to do, like uploading CSV files for each new country. Not sure how else you'd get the country/province/city data into the DB without custom code or a module.

I would want to use views too in order to do things like show all one bedroom condos in a certain city.

It seems hierarchical select in conjunction with content taxonomy would do this in a condensed, easier way.

Not knowing a stitch of PHP or SQL, I can't really program this myself, though it doesn't sound as though it would be that conceptually difficult. I don't even really need AJAX for now. I'd be satisfied with page refreshes.

I only ask if there's another way to do this as it seems the stable version of hierarchical select, especially for use with content taxonomy in D6 is a ways off.

This module does almost what I want but it's D5 only and no indication of being ported to D6, and it appears as if he resorted to autocomplete rather than a large taxonomy - not sure why - a performance hit maybe: http://drupal.org/project/FixedDataDropdown

A Google search for "dependent drop down list php mysql" turns up plenty of examples, including this extension for Dreamweaver: http://www.tecnorama.org/document.php?pageNum_da_comments=3&id_doc=62

This guy has a good explanation with code examples: http://www.javascripttoolbox.com/lib/dynamicoptionlist/

Tnx, Jeff

That link appears to pertain to HS, not this other module I was referring to named Fixed Data Dropdown:

http://drupal.org/project/FixedDataDropdown

I think you didn't catch that when I said "this module". I should have been more clear.

Fixed Data Dropdown does almost everything I want, but the developer seems to have some issue with large taxonomies and prefers autocomplete fields. Not sure I understand what he's getting at.

Two other D5 modules appear to be relevant too: Taxonomy Multi, and Taxonomy Strider, both of questionable status, and no indication of D6 activity.

Again, I think this functionality is so common in websites it should be receiving much higher attention and visibility in D6.

You've done a magnificent job thus far considering your workload, but I'm curious why some other high profile developers in the Drupal community haven't stepped in to help move it along faster, especially in light of many user comments testifying to the importance of this functionality. That said, any guess as to when a stable, and complete D6 version will actually surface?

BTW, the HS module got a write up in Victor Kane's new book, "Leveraging Drupal", on page 345:

"This module is really part of what I would all "the quiet revolution" in Drupal modules, and greatly enhances usability."

....Jeff