Gordon1511
New Member
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?