showing items in 2nd table by selection from 1st

[ericg212]

I have a form which lists the sports and hold their id as sportid in the form. What I need is for the leagues list to show only the leagues of the selected sport rather that all of the leagues which is what it shows now. I believe I need to combine these two statements with an if, but I can't get it.

// listing of current sports
$listSports = "SELECT * FROM Sports ORDER BY sport";
$result1 = mysql_query( $listSports, $con );
if ( ! $result1 )
	die ( "listSports fatal error ".mysql_error() );

// List current leagues
$currentLeagues = "SELECT * FROM Leagues ORDER BY league";
$result = mysql_query( $currentLeagues,$con );
if ( ! $result )
	die ( "currentLeagues fatal error ".mysql_error() );

[swon]

I don't know your fieldnames but try something like this:

<?
$listSports = "SELECT * FROM Sports ORDER BY sport";
$result1 = mysql_query( $listSports, $con );

while($row = mysql_fetch_array($result1){

$sports = $row['sport'];

$currentLeagues = "SELECT * FROM Leagues ORDER BY league WHERE sports = '$sports'";
$result = mysql_query( $currentLeagues,$con );

while($row2 = mysql_fetch_array($result){
echo $row2['league'];
}

}
?>