Mysql count players in clan
#6

Quote:
Originally Posted by Niko_boy
Посмотреть сообщение
try this:
SELECT COUNT(*) AS `CLANTOTAL` FROM TABLE WHERE CLAN = CLANNAME

later..
mysql_fetch_field_row(clanCount,"CLANTOTAL");
now u have ur value in clanCount.

(sorry for bump , i just noticed it while scrolling through forum)
Thanks, do you also know how to return the players in a clan.
Example in DB:
Код:
PlayerName|ClanName
Admigo|Clan1
Test1|clan2
Test2|Clan1
so if i use like GetPlayerMembersInClan(clanname[]) and when i use Clan1 it will return in a string:
Код:
Admigo
Test2
It needs to be threaded.
Reply


Messages In This Thread
Mysql count players in clan - by Admigo - 20.06.2013, 15:07
Re: Mysql count players in clan - by Niko_boy - 20.06.2013, 15:17
Re: Mysql count players in clan - by Vince - 20.06.2013, 15:21
Re: Mysql count players in clan - by Admigo - 21.06.2013, 14:42
Re: Mysql count players in clan - by Niko_boy - 23.06.2013, 05:27
Re: Mysql count players in clan - by Admigo - 23.06.2013, 07:47
Re: Mysql count players in clan - by Vince - 23.06.2013, 10:18
Re: Mysql count players in clan - by Admigo - 23.06.2013, 11:15
Re: Mysql count players in clan - by Stylock - 23.06.2013, 12:52
Re: Mysql count players in clan - by Admigo - 23.06.2013, 12:57

Forum Jump:


Users browsing this thread: 1 Guest(s)