How do I merge two mysql results?

[ShenaCat]

So I have two SQL statements in php:

$sql = "SELECT * FROM users WHERE location='$lid'";
$sql2 = "SELECT * FROM admin WHERE location='$lid'";

$result = mysql_query($sql);
$result2 = mysql_query($sql2);

now I want to merge $result and $result2 into one variable so I can work with them together... how can I do that? Are they just regular arrays..? if I merged them together could I then do a mysql_num_rows($merged_var) function on it...?

Thanks

[Jay]

Output them into an array first, and then manipulate them from there!

[ShenaCat]

The problem is, that'd be a hell of an array

I've decided to use a temporary table and just output what I want from each table into this temporary table and then pull the data from there... it seemed the most expedient method until UNION in mySQL 4.0.0!

[adelinewss]

Can tried with $sql = "select * from users u, admin a where location='$lid' and u.id=a.id";

(u.id and a.id is the key to link the two tables)

* Please note that there must be a key to link the two tables or else the combined sql will not work. Good Luck! :wink:

[ShenaCat]

I tried that already and it doesn't work, because it puts the results all in one row instead of in multiple rows...?

[DoppyNL]

IF in the table `user` users are stored and in the table `admin` administrators, you might want to rethink you're databasestructure...

Personally, I store all users of my site in one table, and use fields to give them certain rights or not.

Greetz Daan