I have a pretty simple MySQL query, that joins two tables:
SELECT teams.id, teams.name, players.id, players.name, players.teamId
FROM teams
LEFT JOIN players
ON teams.id = players.zoneId
WHERE teamId = 3
When I then fetch the rows, I can use the data like this:
echo($row["name"] . ", " . $row["id"]);
The data contained in the array, is the data from the players table. How can I also access the data from the "teams" table ?
Thanks.