Bug #16029: Feature Request on mysql_fetch_array()

From: mjm@porter.appstate.edu Operating system: Linux 2.4 (intel) PHP version: 4.1.2 PHP Bug Type: MySQL related Bug description: Feature Request on mysql_fetch_array() When you SELECT two columns from different tables with the same column name in a JOIN, you cannot use column names is associative array keys. It would be really nice when you did something like this: ------- $result = mysql_query("SELECT tbl1.colA, tbl2.colA FROM tbl1 LEFT JOIN tbl2 ON tbl1.colB = tbl2.colB"); $row = mysql_fetch_array($result); ------- if you could then do something like this: ------- $mydata1 = $row["tbl1.colA"]; $mydata1 = $row["tbl2.colA"]; ------- With the current behavior, you may only access the second array element with its numerical index. -- Edit bug report at http://bugs.php.net/?id=16029&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=16029&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=16029&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=16029&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=16029&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=16029&r=support Expected behavior: http://bugs.php.net/fix.php?id=16029&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=16029&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=16029&r=submittedtwice