[RESOLVED] Opening data based upon user selection

j_w_Bruce

Ok, this one should be easy...

I have a php form that loads a combo box (select box in html speak)

The part I can't figure out...

Based on what the USER selects in the combo box, I want to show ALL of the items in another table that has been associated with it.

For example:
if the user selects "OPTION1", then I want to go to my data table and get all the records that have "OPTION1" in the type field.

The problem I'm having is that the only way I know to get that data is by reloading the page, but if I reload the page, I wipe out whatever the user has picked...

Any Ideas...

bradgrafelman

If you don't want to reload the page, you'll have to delve into something like AJAX and using Javascript to make HTTP requests and change the data displayed.

Otherwise, you can easily reload the page without losing their selection... here's an easy example:

<select name="whatever">
<option value="option1" <?php echo (($selection == 'option1') ? 'selected' : ''); ?>>Option 1</option>
<!-- etc. - same for all options in SELECT box -->
</select>

SpinCode

Hi,
I think what you need to know can be found here:

http://www.addedworth.com/php/index.php?t=PHP_SELECT_BOX_TUTORIAL

It's a short and precise tutorial regarding remembering selected options in a select box.

Cheers.
Spin

j_w_Bruce

Thanks. Works like a champ.

I'm goign to mark this one resolved, because my problem now hasn't anything to do with the Ajack and updating page.