20.06.2012, 19:09
how to calculate the total users registred, into the database ? i use BlueG MySQL Plugin
mysql_query("SELECT * FROM users");
new total_registered_users = mysql_num_rows();
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");
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();
Why would you select everything? A waste of memory.
pawn Код:
|