[Neil.]

Quote:

Originally Posted by Sinner Код: SELECT COUNT(*) FROM `banlog` WHERE `banned` = 1 GROUP BY name Will return the number of users banned. If you can solve your problem in the query, as opposed to using more functions in pawn afterwards, do it.

Being a noob n' all and still just learning MySQL
I came up with this:

pawn Код:

stock bancount(playerid)
{
    new row[24];
    mysql_query( "SELECT COUNT(`name`) FROM `banlog` WHERE `banned` = '1' GROUP BY name" );
    mysql_store_result();
    mysql_free_result();
return 1;
}

Am I doing it wrong?