Display column from SQL query with same name

Question

how can I display the name of both teams (lteam and vteam)? Query works now... This is a screenshot of the SQL results: http://prntscr.com/f9mkqh

$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 '<table>';
echo '<tbody>';

foreach($pdo->query($sql) as $row)
    {
    echo '<tr>';
    echo '<td>' . $row['lteam'] . '</td>';
    echo '<td>' . $row['name'] . '</td>';
    echo '<td>-</td>';
    echo '<td>' . $row['vteam'] . '</td>';
    echo '<td>' . $row['b.name'] . '</td>';
    echo '</tr>';
    }

echo '</tbody>';
echo '</table>';

Thanks!

OptimusCrime · Accepted Answer · 2017-05-19 10:32:06Z

1

The SQL result header is somewhat confusing, and as I don't know fully how the tables and schemas are structured, I have to assume you are having trouble with getting the name attribute from the teams table, as this is joined in two times.

You will need to select the columns explicitly and naming them something else for this to work. For example:

SELECT *, `a`.`name` as `team1name`, `b`.`name` as `team2name` FROM fixtures [...]

Now you should be able to grab the team names under their assigned aliases.

answered May 19, 2017 at 10:32

OptimusCrime

14.9k13 gold badges63 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Robin Alexander Over a year ago

You are the boss! Thanks!

Collectives™ on Stack Overflow

Display column from SQL query with same name

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related