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.