mysql counting rows in accounts table
#2

Try this:

pawn Code:
mysql_query(mysql, "SELECT * FROM `accounts`"); // I always use SELECT ID or something else rather than everything (*)

new rows;
cache_get_row_count(rows);

format(string, sizeof(string), "{FFFF00}%s [%d] has successfully registered. [Total Accounts: %d]", pName(playerid), playerid, rows);
Reply


Messages In This Thread
mysql counting rows in accounts table - by Filbert - 20.05.2020, 20:21
Re: mysql counting rows in accounts table - by jasperschellekens - 20.05.2020, 21:09
Re: mysql counting rows in accounts table - by Filbert - 21.05.2020, 04:44
Re: mysql counting rows in accounts table - by SharpenBlade - 21.05.2020, 05:43
Re: mysql counting rows in accounts table - by Calisthenics - 21.05.2020, 07:11
Re: mysql counting rows in accounts table - by SiaReyes - 21.05.2020, 07:12
Re: mysql counting rows in accounts table - by Filbert - 21.05.2020, 09:57

Forum Jump:


Users browsing this thread: 1 Guest(s)