[MRM]

Hello.
How i get number of one field in table ?

PHP код:

format(query, sizeof(query), "SELECT * FROM users WHERE `clanname` = '%s'",player[playerid][cClanNamePlayer]);
mysql_function_query(1, query, true, "OnClansMemberLoad", "d", playerid); 


Thanks.

[Spenker]

Код HTML:

forward OnClansMemberLoad(playerid);
public OnClansMemberLoad(playerid)
{
    if(cache_num_rows())
    {
        //MySQLCon = Your MYSQL connection.
        //pInfo[playerid][pUser] = String.
        cache_get_field_content(0, "NameUser", pInfo[playerid][pUser], MySQLCon, MAX_PLAYER_NAME);
    }
    return 1;
}

[MRM]

Quote:

Originally Posted by Spenker Код HTML: forward OnClansMemberLoad(playerid); public OnClansMemberLoad(playerid) { if(cache_num_rows()) { //MySQLCon = Your MYSQL connection. //pInfo[playerid][pUser] = String. cache_get_field_content(0, "NameUser", pInfo[playerid][pUser], MySQLCon, MAX_PLAYER_NAME); } return 1; }

How i printf number of members?Why isn't integer?

PHP код:

printf("number of members: %s",pInfo[playerid][pUser]); 


This is true?

[FrAnKiN1]

ofc not use %i or %d

[MRM]

This is string.

[MRM]

How i can get COUNT from mysql?

PHP код:

format(query, sizeof(query), "SELECT COUNT(`id`) FROM users WHERE `clanname` = '%s'",player[playerid][cClanNamePlayer]); 
mysql_function_query(1, query, true, "OnClansMemberLoad", "d", playerid); 


[Shinja]

Bumb