Multiple tables with matching field names

[Buzz.]

Hi, in mysql I am used to handling matching field names across tables like:-

 

select date,tableone.sname,tabletwo.sname from tableone left join tabletwo on tableone.id=tabletwo.id;

 

but using this method with php doesn't seem to work for me

$result=mysql_query("select date,tableone.sname,tabletwo.sname from tableone left join tabletwo on tableone.id=tabletwo.id order by date",$sqlconn);

 

$sname=mysql_result($result,$i,".tableone.sname");

$sname2=mysql_result($result,$i,"tabletwo.sname");

 

I only seem to get 1 "sname" value, ie.

$sname=mysql_result($result,$i,"sname");

 

I've tried to search for examples of this but failed, please help a php newbie :-)

[fenway]

You need to use column aliases, since they both have the same name, so you're getting hash key collision.