Table Links

[slevytam]

Hello,

Could someone spare a quick second to explain this.

I have a query that looks something like this.

Select * from table1, table2 where ....

The problem is that both table1 and table2 have a column of the same name.

So if call
$row=mysql_fetch_array(....
then,
echo $row['columnname'];

I only get the data from table1.

I tried echo $row['table2.columnname'] but this doesn't work either.

Does anyone have a solution other then changing the column name?

Thanks,

--SL

[ahundiak]

Read up on aliases for sql queries.

"SELECT
whatever.table1 AS whatever1,
whatever.table2 AS whatever2
FROM table1,table2; "

echo $record['whatever1'];
echo $record['whatever2'];

Lot's of neat stuff in sql.