[SOLVED] Faction game help

[tom2oo8]

Ok im new to php but have made the rest of my game.

 

factions in this are group of members who work together to get the most money.

 

Im trying to get a ranking system to:

 

find the users in a specific faction add up all there money, I know how to rank them once ive done that but i really dont know where to start and how i would go aabbout doing this so if any one could help thanks.

 

And hi to everyone just signed up

[Mchl]

Looking for a query you mean?

 

SELECT SUM(money) AS money, faction FROM players GROUP BY faction ORDER BY money

[tom2oo8]

Thanks but would that work if

 

in the database it was like this:

 

Tables:

 

Users----has users money and faction name in it

 

and

 

faction --- has faction name and TOTAL money

 

So is there any way of working out the total money?? it would have to:

 

check if user is in a faction

Check the users who are in the same faction

add there money up???

 

 

 

Sorry for making you or anyone else basiclly write the code i wouldnt mind if you pointed me in the right direction

 

 

 

 

[tom2oo8]

Wait dont worry lol

i realised i dont actually need another table

Thanks it help me sooo much

Also my host dont actually tell me what msql version it is

 

 

fixed it

[Mchl]

You can easily check mysql server version from PHP

http://www.php.net/manual/en/function.mysql-get-server-info.php

[tom2oo8]

You can easily check mysql server version from PHP

http://www.php.net/manual/en/function.mysql-get-server-info.php

 

 

ooo that helps... Thanks..

 

but 1 last thing

 

how do i get it not to rank users that isnt in a faction?

[tom2oo8]

fixed it ~

 

SELECT SUM(money) AS money, faction FROM users WHERE faction!='' GROUP BY faction ORDER BY money DESC