Query across 2 tables - getting stuck

[swatisonee]

Hi,

Pl. see the foll. code :

I need to create a query such that matches userid from Table Users with ip frm Table Office and if there is no match then to "die", else to proceed further.

Could someone guide me on the IF statement pl? Thanks !

$result = mysql_query ("SELECT * from `users` WHERE  `userid`= '$userid'");
$myrow = mysql_fetch_array($result);
$officeid = $myrow["officeid"]; // THIS  STATEMENT WORKS FINE

$resulta = mysql_query ("SELECT * from `Office` WHERE  `officeid`= '$officeid'");
$myrowa = mysql_fetch_array($resulta);
$ip = $myrowa["ip"]; // THIS  STATEMENT WORKS FINE

IF  (A user from an office logs in with an ip not linked to that office ) die ("You are not authorised to log in from this ip")

[devinemke]

if you are using mySQL 4.1 or higher:

$result = mysql_query("SELECT ip FROM Office WHERE officeid = (SELECT officeid FROM users WHERE userid = '$userid')") or exit(mysql_error());

if (mysql_num_rows($result)) {$ip = mysql_result($result, 0);}
else {exit('no ip found');}

if ($ip != $_SERVER['REMOTE_ADDR']) {exit('You are not authorised to log in from this ip');}

[swatisonee]

Version 3.23.53 I' m afraid.

Any alternates pl?

Thanks.