title: Display column from SQL query with same name
body: <p>how can I display the name of both teams (lteam and vteam)? Query works now... This is a screenshot of the SQL results:<a href="https://i.stack.imgur.com/RXXWm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RXXWm.png" alt="enter image description here"></a>
  <a href="http://prntscr.com/f9mkqh" rel="nofollow noreferrer">http://prntscr.com/f9mkqh</a></p>
  
  <pre><code>$sql = "
  SELECT * 
    FROM fixtures 
    LEFT 
    JOIN teams AS a 
      ON fixtures.lteam = a.id
    LEFT 
    JOIN teams AS b 
      ON fixtures.vteam = b.id
   WHERE date_ko = '2017-05-19'
  ";
  echo '&lt;table&gt;';
  echo '&lt;tbody&gt;';
  
  foreach($pdo-&gt;query($sql) as $row)
      {
      echo '&lt;tr&gt;';
      echo '&lt;td&gt;' . $row['lteam'] . '&lt;/td&gt;';
      echo '&lt;td&gt;' . $row['name'] . '&lt;/td&gt;';
      echo '&lt;td&gt;-&lt;/td&gt;';
      echo '&lt;td&gt;' . $row['vteam'] . '&lt;/td&gt;';
      echo '&lt;td&gt;' . $row['b.name'] . '&lt;/td&gt;';
      echo '&lt;/tr&gt;';
      }
  
  echo '&lt;/tbody&gt;';
  echo '&lt;/table&gt;';
  </code></pre>
  
  <p>Thanks!</p>