[Ugaustin]

hi,can someone tell me how can I make MYSQL,by /123 , There are X player accounts.. but I don't know how..

[Bartels]

Could you provide some more information? I'm assuming you've got a MySQL database and want to count the player accounts? You can do that using MySQL's COUNT function.

[Ugaustin]

yes account name is "account" ... and im new,and I cant find tutorial for this kind,

[d1git]

What you want to do is... SELECT everything from the table ACCOUNTS and then use the inbuilt function; cache_get_row_count(); to get the number of rows.

PHP код:

new query[24];
mysql_format(connection, query, sizeof(query), "SELECT * FROM Accounts;");
mysql_tquery(connection, query, "CheckQuery1");
format CheckQuery1();
public CheckQuery1()
{
    printf("Number of Accounts: %d.", cache_get_row_count());
} 


[Ugaustin]

thanks!reped!

[d1git]

Deleted *Wrong quote*.

[Ugaustin]

it appears that are 0 accounts..don't know wghy..

[d1git]

What is the name of your SQL table that stores your accounts? Replace that with the SQL Query.

PHP код:

new query[24]; 
mysql_format(connection, query, sizeof(query), "SELECT * FROM SQLTableNameInsertHere;"); 
mysql_tquery(connection, query, "CheckQuery1"); 
format CheckQuery1(); 
public CheckQuery1() 
{ 
    printf("Number of Accounts: %d.", cache_get_row_count()); 
} 


[Ugaustin]

forward or format??

format CheckQuery1(); ??

[d1git]

Quote:

Originally Posted by Ugaustin forward or format?? format CheckQuery1(); ??

forward* my bad.