Setting $myrow, columns have same name

[Anon]

I have a query that joins two tables, and a column in each table has the same name..... he query works fine. I am having trouble setting the strings after the query....

===========================

$sql = "SELECT

table1.address,
table2.address

FROM table1

LEFT JOIN table2 on table1.blah1 = table2.blah2";

$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);

if ($myrow) {

$address1 = $myrow["table1.address"];
$address2 = $myrow["table2.address"];

}

===========================

these two lines do not work...... is the syntax wrong inside $myrow[""] ?

$address1 = $myrow["table1.address"];
$address2 = $myrow["table2.address"];

thanks for any help....

[Anon]

$sql = "SELECT

table1.address as ad1,
table2.address as ad2

FROM table1

LEFT JOIN table2 on table1.blah1 = table2.blah2";

$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);

if ($myrow) {

$address1 = $myrow["ad1"];
$address2 = $myrow["ad2"];

}

[Anon]

ayeee..... so simple!

thank you very much.....

Brooks