search criteria from array

[mdnghtblue]

$allies = mysql_query("SELECT num, clan FROM players WHERE clan=$users[clan];");

$market = mysql_query("SELECT * FROM market WHERE time<=$time AND seller=$allies;"); // not sure what to put instead of $allies?

 

How can I limit the second query to the sellers with the "num"s selected from the first query? I kinda doubt the way I set it up above works.

[fenway]

How are these two tables related?

[mdnghtblue]

They're just in the same database. "seller" from market, and "num" from players are the same kind of data. (don't really know how to use relations in mySQL yet =/)

[fenway]

You mean "num" is the ID and seller is the ID from the clan/players table?

 

If so:

 

SELECT p.num, p.clan, m.*
FROM players AS p
INNER JOIN
market AS m ON ( m.seller = p.num )
WHERE m.time<=$time AND p.clan=$users[clan]

 

I'd rename "num"  as player_id and seller as seller_id (or player_id) to make this more obvious.

 

Also, make sure to quote those literals.

[mdnghtblue]

Thanks very much. =)