[SpriTe]

Hello, i have a question.
new Cache:result = mysql_query(handle, "SELECT `username` FROM `players`");
new account = cache_get_row_count(),name[25];
cache_get_field_content(account-1, "username", name, handle, 25);
cache_delete(result);

It's ok this code? But I need to get the number of players who have field "Language" set on value 1, the field is on the players table.

[Vince]

That's not how it works. And for your goal the query should be:

PHP код:

SELECT COUNT(*) FROM players WHERE language = 1