Pull 2 fields associated with same id

[The_Walrus]

my probelm is i am trying to pull 2 fields that associate with the same id:

ex:

$query = "select date, home, away, team.name from sched2k3,team where sched2k3.home=team.teamid";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
echo "<p>Number of games: ".$num_results."</p>";
for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
echo $row["date"]." :: ".$row["name"]." :: <br>\n";
}

?>

thios retrieves the correct records and displays the first team(sched2k3.home) correctly, but I dont know how to get the team name for the 2nd team (sched2k3.away)

I hope that is understandable.

[Lars_Berg]

 $query = "select date, home, away, t1.name,t2.name 
from sched2k3,team t1, team t2 
where sched2k3.home=t1.teamid
and sched2k3.away = t2.teamid ";

[The_Walrus]

I understand the select statement by putting from team t1, it basically renames the table? but now, I im still having a problem displaying the 2 fields.

I was using a for statement

echo $row["date"]." :: ".$row["home"]." :: ".$row["away"]."<br>\n";

which will call the date and the away and home team ID numbers, and still does, however, i dont now how to display the team names. I can use $row["name"] for the home team, but no idea for the away team?

[The_Walrus]

in my select statement, do I need to use as, rather then just tablename newtablename? Is that what could be messing me up?

[Lars_Berg]

Using as is a solution using ordinal number in $row is another.

Using tablename.columnname is not a solution.

[The_Walrus]

OK I didnt even now you could use a number. I'm very sure this will work now, so thank you very much for your help.