MySQL join two tables and retun data from both tables
===

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.
