Same filed name Different table

[Fritz]

I've got a three table join... and it seems to work fine...

Problem.

I am trying to view a column in the main table BUT this column has the SAME NAME and that of one of the join tables...

SO... I thought all I needed to do was specify the row call as.

$table1.fieldname = $row['$table1.fieldname']; 

all the other fields in this table ARE displaying...

Thoughts?

[hand]

Please post the select statement

[remote2]

maybe you can use index to reference...

$t1.fieldname = $row[$i]

where $i is an integer corresponding to that column in your result

or
try this...

select username as username1 from user

SELECT username AS username1, username AS username2 FROM user

this rename my username column into username1 and 2