Query with 2 Tables.

[WinterDragon]

Alright so I am trying to query two tables at once, but the tables have a column that is named the same thing... so i do not know how to echo it out... so here is the query..

SELECT gamer.*, world.* FROM gamer, world WHERE gamer.name='Jonathan' AND world.room='0x0x0' LIMIT 1

This pulls in the right data, but it seems the world.name has overridden the gamer.name, (it does pull the right information though)... I don't know why, but it doesn't get the name 'Jonathan' for some reason, if I run this through a mysql_fetch_array(), and echo $row[name], it shows world.name and not gamer.name, can anyone help me in solving this issue? Thank you.

[LordShryku]

You'd need to specify the columns to pull and alias them.

SELECT g.name AS gname,
       w.name AS wname
  FROM gamer g, world w
 WHERE g.name='Jonathan'
   AND w.room='0x0x0' 
 LIMIT 1

Then, in your array, they'd be gname and wname.