Grouping data...help

[mahniti2003]

Well, I have database like this...

[League],[Team A],[Team B]...[n]
A xxx yyy
A xxx yyy
A xxx yyy
B xxx yyy
B xxx yyy
B xxx yyy
C xxx yyy
C xxx yyy
C xxx yyy

...and want to display results like this

A

xxx yyy
xxx yyy
xxx yyy

B

xxx yyy
xxx yyy
xxx yyy

C

xxx yyy
xxx yyy
xxx yyy

...anyone got the idea...can help me?
Thanks!😕

[sgoku01]

You could do this:

$query = mysql_result(mysql_query( "SELECT * FROM database ORDER BY Leage" ));

$leage = '';

while ( $row = mysql_fetch_row($query) )
{
     if ( empty( $leage ) )
     {
     $leage = $row['leage'];
     echo $row['leage'] . '<br>';
     }

 if ( $row['leage'] == $leage )
 {
 echo $row['TeamA'] . $row['TeamB'] . '<br>';
 }
 else
 {
 echo $row['leage'] . '<br>';
 echo $row['TeamA'] . $row['TeamB'] . '<br>';
 }

$leage = $row['leage'];

} // END WHILE 

I think this script has to work..

[mahniti2003]

$query = ("SELECT League,TeamA,TeamB FROM table ORDER BY League" );
$result = mysql_query($query);
$liga = '';

while ( $row = mysql_fetch_row($result) )
{
if ( empty( $liga ) )
{
$liga = $row[0];
echo '<b>' . $row[0] . '</b><br>';
}

 if ( $row[0] == $liga )
 {
 echo $row[1] . ' - ' . $row[2] . '<br>';
 }
 else
 {
 echo '<b>' . $row[0] . '</b><br>';
 echo $row[1] . ' - ' .  $row[2] . '<br>';
 }

$liga = $row[0];

} // END WHILE

thanks...script with this modifications is working...