multiple table pull, MySQL

[monkeymade]

$result = mysql_query("SELECT $tb1.fname FROM $tb1, $tb4 WHERE $tb1.email = '$T1' AND $tb1.pass = '$T2' AND $tb1.unum=$tb4.unum",$db) or die(mysql_error());
		$_SESSION['myfname'] = mysql_result($result,0,"$fname");

 

The error I get is:

 

Warning: mysql_result() [function.mysql-result]: not found in MySQL result index 6 in /home/xratedda/public_html/loginout.php on line 39

 

I know, it looks like I am only grabbing one thing and don't need different tables, but I am trying to figure out how to do this with just one item, before adding the rest.

 

Someone please help me out here

[xenophobia]

Your variables is confusing. ???

 

You do this:

SELECT $tbl.fname ....

 

and you retrieve this:

mysql_result($result,0,"$fname");

 

?? You have a variable name $fname = "fname"; ?

 

and the variables $tbl, $tb4 is assigned to your table name?

 

Check all your variables. Selecting multiple table will sometimes slow down the process. Try use 2 query. Much faster.

 

Hope this help you

[monkeymade]

well, don't I feel stupid....

 

$_SESSION['myfname'] = mysql_result($result,0,"$fname");

 

should have been:

 

$_SESSION['myfname'] = mysql_result($result,0,"fname");

 

Thanks for pointing that out lol