question about mysql_select_db

[desjardins2010]

hey curious this code here i'm using from another script to make things quicker for me however the two querys here were on the other script picking from the same place IE: members in table heaven_users

 

this new script however will need the forst query for pull from heaven_npc so i tried

$query = mysql_query("SELECT * FROM 'heaven_users' 'members' WHERE username='$player'");

this script below given this error

 

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''heaven_users' 'members' WHERE username='solidsoul'' at line 1 "

 

here the whole script

include('connectnpc.php');

	$query = mysql_query ("SELECT * FROM npcs WHERE ipaddress='$npcip'") or die (mysql_error());
	$query2 = mysql_query ("SELECT * FROM 'heaven_users' 'members' WHERE username='$player'") or die (mysql_error());

the connectnpc.php connects and sleects heave_npc

[desjardins2010]

opps no there is the . in between them 'heaven_users' . 'members'

[desjardins2010]

that still don't work

[BlueSkyIS]

$sql = "SELECT * FROM 'heaven_users.members' WHERE username='$player'";
$query = mysql_query($sql) or die(mysql_error() . " IN $sql");

[desjardins2010]

thanks alot..