[Fj0rtizFredde]

You could use COUNT() Like this:

PHP Code:

SELECT COUNT(*) FROM accounts 


I think you also can use "mysql_num_rows" and do something like this:

pawn Code:

mysql_query("SELECT * FROM accounts");
mysql_store_result(); 
new rows = mysql_num_rows(); 
mysql_free_result();
 
printf("There are %d accounts",rows);