note 32309 added to function.mysql-query

I have little problem $result=mysql_query("select * from A left join B on xxx"); $row = mysql_fetch_result($result); I have colum name 'money' in table A and I also have the same column name 'money' in B too (yes, they are different and independent) How can I access them to get different value from this query. ? $row['money'] or $row['money_1'] or $row['B.money'] didn't work. Thanks very much. ---- Manual Page -- http://www.php.net/manual/en/function.mysql-query.php Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+32309 Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+32309&report=yes Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+32309&report=yes