Re: Passing dropdown list value to another SELECT statement on same page

[Jack Berberette]

Oh...I just thought about something. In this situation, I'm actually only polling one table. The dropdown list is called from the first colum of table 'Races'. That fisrt colum is called 'racename'. From that selection, the table gets created and displays the remaining five colum values for that selection.

So the db table is structred like this:

racename || mightmod || valormod || deftnessmod || insightmod || dweomermod

when the 'racename' is selected from the dropdown, the table that gets displayed shows the following for the name chosen:

mightmod || valormod || deftnessmod || insightmod || dweomermod

Here's the page I'm playing with that shows the dropdown and the full 'Races' table if that helps:

http://www.gamehermit.com/mysqltest2.php