Bug #16028: mysql_fetch_array() fails to index array correctly

From: mjm@porter.appstate.edu Operating system: GNU/Linux 2.4 (intel) PHP version: 4.1.2 PHP Bug Type: MySQL related Bug description: mysql_fetch_array() fails to index array correctly After some frustration, I performed the following SELECT query (column names have been changed): $result = mysql_query("SELECT tbl1.colA, tbl2.colB, tbl2.colC FROM tbl1 LEFT JOIN tbl2 ON tbl1.colD = tbl2.colD WHERE tbl1.colE = "myvalue" ORDER BY tbl1.colF DESC, tbl2.colC ASC, tbl2.colD ASC", $handle); I executed the following statements: $row = mysql_fetch_array($result); print_r(array_keys($row)); The output looked like this: Array ( [0] => 0 [1] => 1 [2] => colB [3] => 2 [4] => colC ) This doesn't make any sense. When you SELECT from a LEFT JOIN it would make sense for you to be able to access the array like this (IMHO): $row["tbl2.colB"], $row["tbl2.colC"], etc... since two columns in the select could have the same name but different values. -- Edit bug report at http://bugs.php.net/?id=16028&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=16028&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=16028&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=16028&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=16028&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=16028&r=support Expected behavior: http://bugs.php.net/fix.php?id=16028&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=16028&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=16028&r=submittedtwice