[TheBluec0de]

how to calculate the total users registred, into the database ? i use BlueG MySQL Plugin

[Pizzy]

SELECT NULL FROM <userdb>

new tRows = mysql_num_rows();

tRows = How many users are in the <userdb>.

[Mandrakke]

pawn Код:

mysql_query("SELECT * FROM users");
new total_registered_users = mysql_num_rows();

edit: too late.

[TheBluec0de]

Thanks

[TheBluec0de]

exactly is this, correct ?

PHP код:

    format(query, sizeof(query), "SELECT * FROM `%s`", TABLE_NAME);
    mysql_query(query);
    
    mysql_store_result();
    
    new
        total_users = mysql_num_rows();

    mysql_free_result();

    print("-----------------------------------------------------------------------------");
    printf("MySQL: The are %d users registred", total_users);
    print("-----------------------------------------------------------------------------\n"); 


[TheBluec0de]

bump

[ReneG]

Why would you select everything? A waste of memory.

pawn Код:

format(query, sizeof(query), "SELECT COUNT(*) FROM `%s`", TABLE_NAME);
    mysql_query(query);
    
    mysql_store_result();
    
    new
        total_users = mysql_fetch_int();

    mysql_free_result();

Or whatever function gets the integer from the field.

[TheBluec0de]

Quote:

Originally Posted by VincentDunn Why would you select everything? A waste of memory. pawn Код: format(query, sizeof(query), "SELECT COUNT(*) FROM `%s`", TABLE_NAME);     mysql_query(query);         mysql_store_result();         new         total_users = mysql_fetch_int();     mysql_free_result(); Or whatever function gets the integer from the field.

Thanks