Help me SELECT this>>>

[localhost]

Hello,
This is my problem

I have 2 tables

USERS:userid,name,city,pass
STATISTICS:setid,userid,totalscore,score

i do this SELECT>>>>

$statistics = mysql_query("SELECT * FROM statistics WHERE setid='".$no."' ORDER BY score DESC, totalscore $limit" );

the problem is that i want to SELECT the same as above
but limited to users which userid correspond to a city
but city exists only in table USERS,so the only way to do this is
by getting users city by useid BUT HOW??

[Rodders]

You need to use a JOIN in your query.

$statistics = mysql_query("
SELECT *
FROM statistics, users
WHERE statistics.setid='".$no."'
AND statistics.userid = users.userid
AND users.city = '".$city."'
ORDER BY statistics.score DESC, statistics.totalscore $limit" );

All I've done is added the users table to the query, and joined them on userid. Then I added the 'city' criteria.

[localhost]

thanks a lot for your help 😃

[Rodders]

'twas a pleasure !