ID: 16028
Updated by: [EMAIL PROTECTED]
-Summary: mysql_fetch_array() fails to index array correctly
Reported By: [EMAIL PROTECTED]
-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] [EMAIL PROTECTED]
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
