[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());
}