[Mark_Weston]

Easy, I assume you want to could all registered players on the server from the database?

This is what I did:

[pwano]
CMD:registeredplayers(playerid, params[]) {
mysql_query("SELECT * FROM `accounts`");
mysql_store_result();
new string[128];
format(string, sizeof(string), "[SERVER]: There are currently %d currently registered players.", mysql_num_rows());
SendClientMessage(playerid, COLOR_LIGHTBLUE, string);
mysql_free_result();
return 1;
}
[/pawno]

* means ALL

samething can be done for total houses, total businesses, total tickets, etc.