title: Echo results of a complicated INNER JOIN query with multiple tables
body: <p>This is my first question here. I have a complicated SQL database and I need to join different tables which have the same column names.</p>
  
  <p>"event" is a sports match. It contains tournament_stageFK which is linked to tournament_stage table, which contains tournamentFK which is linked to tournament table, which contains tournament_templateFK which is linked to tournament_template table, which contains sportFK which is linked to sport table.</p>
  
  <p>So in order to find out what sport the match is from, I need to do an inner join, otherwise I'd have to open the database millions of times. The only way to do it is this, but I don't know how to display the results. My poor attempt to echo the results is below:</p>
  
  <pre><code>$SQL = "SELECT sport.name,
  country.name, 
  tournament_template.name, 
  tournament.name, 
  tournament_stage.name, 
  event.* 
  FROM tournament_template 
  INNER JOIN sport
  ON tournament_template.sportFK = sport.id 
  INNER JOIN tournament ON tournament.tournament_templateFK = tournament_template.id 
  INNER JOIN tournament_stage ON tournament_stage.tournamentFK = tournament.id 
  INNER JOIN event ON event.tournament_stageFK = tournament_stage.id 
  INNER JOIN country ON tournament_stage.countryFK = country.id 
  WHERE DATE(event.startdate) = CURRENT_DATE() 
  ORDER BY sport.name ASC, 
  country.name ASC, 
  tournament_stage.name ASC, 
  event.startdate ASC"; 
  
  $result = mysql_query($SQL);
  
  while($get=mysql_fetch_array($result))
  {
  echo $result['event.name'];
  echo "&lt;br&gt;";
  }
  </code></pre>