Little problem with sql

[Faraonekkk]

Helloo,


I got this:
$query = mysql_query("SELECT id, owner FROM houses WHERE id = 2");
$id1 = $get1['id'];
i have added
$owner1 = mysql_query("SELECT name FROM players WHERE id = '$id1'");

and i have "Resource id #15"

Its showing house owner id "2" and i wanna to show the name of this owner id
help ;p

thanks

 

[Zisly]

Could you post the whole code?

 

[Cykotitan]

• use PDO/mysqli
• LEFT JOIN
• PHP: mysql_fetch_array - Manual

 

[Faraonekkk]

$result = mysql_query('SELECT `players`.`name`, `houses`.`id`, `houses`.`owner` FROM `players`, `houses` WHERE `houses`.`id` = 1;');
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {



echo'<tr><td align="left" width="10%"><b>Thais</b></td><td align="center"></td></table></tr>';}


mysql_free_result($result);

I have just write now 6x thais :/ idk why 6x, it should be one, anyone know?