title: PHP MySQL mysql_fetch_assoc with array keys distinguished by 'as' designations
body: <p>Say I do a self-join like <code>select * from table as t1 LEFT JOIN table as t2 ON t1.id=t2.rank</code>, then fetch results to build an array in php using <code>mysql_fetch_assoc</code>... then <code>print_r</code> the array... Is there a way (not just numbers, but using associative identifiers) to distinguish the columns selected in the join, vs the original?</p>