Echoing same field name from two tables

[netrox]

I wrote this code:

$query="SELECT * from tb1, tb2 where tb1.name='jeff' and tb2.name='jen'";
$result = mysql_query($query);

while ($rows = mysql_fetch_object($result))
{
echo $rows->tb1.name;
}

In SQL statement, it worked (phpMyAdmin showed the results correctly) but PHP seem not to understand the rows->tb1.name variable. How do I make PHP echo the right fieldname from ONE table even though two tables may have the same fieldname?

-jeff

[devinemke]

you could use aliases:

$query="SELECT *, tb1.name AS tb1_name, tb2.name AS tb2_name from tb1, tb2 where tb1.name = 'jeff' and tb2.name = 'jen'";
$result = mysql_query($query);
while ($rows = mysql_fetch_object($result))
{
	echo $rows->tb1_name;
}

[netrox]

Tried that and it doesn't work. It doesn't echo what I wanted it to echo. I tried the SQL statement and it gave expected results.

-jeff