Bug #16028 Updated: mysql_fetch_array() indexing on joins

ID: 16028 Updated by: mjm@porter.appstate.edu -Summary: mysql_fetch_array() fails to index array correctly Reported By: mjm@porter.appstate.edu -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: GNU/Linux 2.4 (intel) PHP Version: 4.1.2 New Comment: Oops, did query on bad table. Previous Comments: ------------------------------------------------------------------------ [2002-03-12 19:23:02] mjm@porter.appstate.edu 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 this bug report at http://bugs.php.net/?id=16028&edit=1