mysql_fetch_object without replace

[edup_pt]

I,

I'm using the mysql_fetch_object function.
That's one of my favorites. But when i try to use that in a query that has two tables "A" and "B", and wich tables has one field called name: A:name B:name , it doesn't work very well, cause the second replace the first one.

example:
value name in A: test
value name in B: test2

$sql="select * from A,B where A.id_b=B.id_b";
....
$obj=mysql_fetch_object($rs);

echo $obj->name; //just write me test2

How can i get the test....

Thanks in advance

[sgbalsekar]

hi,

this cud be because it may not be able to differentiate b/w the two name fields...use an alias (select name as Aname) ....may be that shud help...

regs,
sachin balsekar