01.$strSQL = "SELECT * FROM match AS m, team AS t WHERE m.team_id = t.team_id";
02.$result = mysql_query($strSQL);
03.while($row = mysql_fetch_array($result))
04.{
05.
06.echo 'Team ID : '.$row['team_id'].'<br />';
07.echo 'Team Name : '.$row['team_name'].'<br />';
08.echo 'Match ID : '.$row['match_id'].'<br />';
09.echo 'Time : '.$row['time'].'<br />';
10.
11.}
