Two MYSQL tables with same field name

[flyfishi]

Help...below is a some PHP code that works well except I can not get it to display the data from both "NAME" fields from the two tables. This isn't msaccess is it Toto.....

$sqlQuery = "SELECT a.NAME, b.NAME";
$sqlQuery .= " FROM REPORT a, AUTHOR_INFO b";
$sqlQuery .= " WHERE a.AUTHOR_KEY = b.AUTHOR_KEY";
$sqlQuery .= " ORDER BY a.NAME ASC LIMIT ".$limit;

$result = mysql_query($sqlQuery);
$numRows = mysql_num_rows($result);

?>

<?php

if ($numRows > 0) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

?>
<table cellspacing="0" cellpadding="5" class="formTable">
<tr>
<td class="headerT">Date:&nbsp;<br /><br /></td>
<td class="cellT" valign="top"><?= $row['NAME'] ?></td>
</tr>

[khaldryck]

select a.name as aname, b.name as bname ...

to get them in your array :
$row["aname"]
$row["bname"]

[flyfishi]

It seems simple now........Thank you so much. I was close with $row["a.name"]
$row["b.name"] but no cigar.....Thanks again.........lee