MYSQL Help
#1

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.
Reply
#2

That's not how it works. And for your goal the query should be:
PHP код:
SELECT COUNT(*) FROM players WHERE language 
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)