HELP: same name field in Join NOT showing

[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.
PHP:

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

YET this call is displaying ZERO results.

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

Thoughts?

[ahundiak]

To quote the php manual
"
If two or more columns of the result have the same field names, the last column will take precedence. To access the other column(s) of the same name, you must use the numeric index of the column or make an alias for the column. For aliased columns, you cannot access the contents with the original column name (by using 'field' in this example).

Example 1. Query with duplicate field names

select table1.field as foo table2.field as bar from table1, table2

"