Make options list behave upon event on page

[alfalf]

Hello all!

As newbie, perhaps I'm asking to much, but:

I have two options lists on one PHP (phtml) page:
1. Countries (based upon mySQL table)
2. States (also based upon mySQL table, every state belongs to a certain country!).

Now, I want my States options list to show only those values that correspond to a selected Country.
Filtering and display of States data should occure the moment I select Country from country options list.

Q: Is this a PHP question at all?
Q2: Perhaps HTML solution? Such as Form in Form?
Q3: At the end, is it too much tricky to make this work anyhow?

In HTML, SQL and table design am NOT NEWBIE.
I use W2K, Apache2, PHP4, MySQL4.

Thanks for any suggestion!

 

[sleipnir214]

To make the change happen automatically, it's a Javascript question.

Javascript must either force a page reload with the new values, or populate the dropdowns itself.



Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!