I am just starting to get to grips with inner joins but I cannot see how to reference a given column in the result e.g. normally for unique columns I would just reference each column as $row['colname'] but where there are multiple tables with the same column name e.g. table1.name, table2.name etc. the reference $row['table1.name'] does not work - can anyone help me out? Thanks in advance!