mysql

[ilyfxan]

Вот так выводит лидеров имена

format(qs, sizeof(qs), "UPDATE Name, Leader, Member FROM `users` WHERE `Leader` > 0");
format(qs, sizeof(qs), "SELECT Name, Leader, Member FROM `users` WHERE `Leader` > 0");

А вот так кол-во игроков состоящих во фракции

format(qs, sizeof(qs), "UPDATE Name, Leader, Member FROM `users` WHERE `Member` > 0");
format(qs, sizeof(qs), "SELECT Name, Leader, Member FROM `users` WHERE `Member` > 0");

Как сделать чтобы сразу выводились и лидеры,и кол-во игроков во фракции?

if(mysql_num_rows())
{
for(new i = 0; mysql_fetch_row(str_mysql, "|"); i++)
{
mysql_fetch_field("Member", str); Member = strval(str);
mysql_fetch_field("Leader", str); Leader = strval(str);
mysql_fetch_field("Name", str);
if(Member == GetPVarInt(playerid, "Leader"))x++;
if(Leader == GetPVarInt(playerid, "Leader"))format(line, sizeof(line), "{34c924}%s ", str), strcat(info, line);
}
}
mysql_free_result();
format(line, sizeof(line), "\n{FFFFFF}Игроков в организации: {34c924}%d игроков.", x), strcat(info, line);