best way to create 2 queries?

[boionfire81]

Ok, my user table has a "residence" column and by default there are money and bank columns.

I want to list the richest cities and most populated cities in the game.

Now that I think about it could just do a num_rows for population.

But still stuck on the queries needed to tally the money.

Haven't been coding much the past couple days. Not to mention mcc hasn't been much on my mind as I'm only integrating it into a different "business" script. It was called SimLand. I've got most of the malfunctions fixed. Well at least half :P

I think this is a great mix from a simple apply and login.

[SRB]

SELECT cityname, SUM(money) AS money, SUM(bankmoney) AS bankmoney
FROM users
LEFT JOIN cities ON (cities.cityid = users.residency)
GROUP BY residency;

[SRB]

Thanks Guest.

[SRB]

No Problem, Dude. #iHazSomeManners #PutSomeRespecOnMyName

[boionfire81]

lol. My bad man, I'm just now making it back to this thread. But thanks! Will let you know if it works out.