Passing PHP between forms on same page

[nmutimer]

Many thanks in advance to all who offer help.

Yep, yet another newbie question. So new to php it is causing a real headache

On my webpage i currently have two drop down boxes for user selected options where the selection comes from different MySql tables. The first box display ok, without any issue, but the second will not as when the page is first loaded, the variable being used to define the selection is blank as the first box has not been chosen.

How to refresh the page or do whatever is necessary, so that when the user choses their selection form the first drop down, then that choice can be used to define the WHERE element of the mysql query.

[mwasif]

You can use javascript event onchange on the first dropdown to submit the values on the same page. And you should query for the 2nd dropdown only when the value is provided.

[devbanana]

Or you can use AJAX. When the first dropdown is changed, retrieve the values for the second dropdown through AJAX. You'll need to do a lot of reading and studying for that one though if you've not studied it yet.

[byron3@earthlink]

Does this code help:Plus2net: