dropdown based on dropdown

[skeppens]

Hi,

Is it possible to create the following with only using PHP and all happening on 1 page (so no Javascript):
- from the 1st populate (odbc) dropdown box the user selects 1 row.
- automatically the 2nd dropdown gets populated from the database based on the section of the 1st.
- after selecting something in the 2nd one, a table gets populated based on the selection from the 2nd dropdown.

Sandra

[altexis]

PHP produces a page and sends it to the client. After that point the page is treated as static. So you will have to use javascript.

Maybe you could do a trick with a multiple framed page and each time the user selects one option from one frame another frame is refreshed with the proper parameters...

but all this can so easily be done with javascript

[sarah]

altexis is right...since PHP is rendered on the server, you can't perform what you're talking about without refreshing the page. JavaScript can do it and pretty smoothly, but for important stuff, you can't really assume that the user will have JavaScript enabled. You can do it all on one page, but you would have to refresh it in order for PHP to get the data from the first dropdown. Just use the new data to populate the refreshed page.

[cgraz]

use javascript. Here's a link that has exactly what you're looking for.

http://webdeveloper.earthweb.com/webjs/jsnavigation/item.php/91311

Cgraz