链式选择框 - 基本

I have built this page: http://excelwrestling.com/poola.php for an upcoming dual tournament. I have most all of the data being pulled from my mySQL database, with just some sample data in there now.

I am looking to chain the select boxes, so when the user chooses TEAM 1 (at the top), then it will update all of the WRESTLER 1 select boxes with only names from that team. Same thing for team 2.

Another part of this is, is when a person chooses WRESTLER 1 vs WRESTLER 2, I want those two names to fill in the WINNER field, so the user can choose between those two names only.

Anything you can explain to me, or code you could post would be much appreciated.

Thank you!

You probably want to use special queries to get wrestlers from teams. Then use a while loop to update all the wrestlers on a team from an array. Then assign the array to special select index numbers from the database. Can you show whats in the database? I need to know in order to help. Since I don't know whats in your database. I'll just guess how your database is organized. Say that your team drop down list is called team_select and that each wrestler in the wrestler table had a wrestler_id wrestler_name and a team_id.

You would do the following code

     $team_select = $_POST['team_select']

            $wrestler_query = "SELECT wrestler_name FROM wrestler WHERE team_id = " 
. $team_select;

            $query = mysqli_query($connection, $wrestler_query);
            //Repeat code from here... (see bottom)
            while( $team_select = mysqli_fetch_assoc($query));
            {
               echo '<option class="Select1" value="' . $team_select['wrestler_name'] . '">'</option>
            } 
        <?
          </select>

        <?php
        mysqli_data_seek($accounts,0);
     //..to here for other drop down lists (except give the different names of different drop down lists in the html.)

Also don't forget, the connection variable is the database access credentials.