mysql counting rows in accounts table
#1

So I just put this to my register action :

PHP Code:
...
new 
registered[24], Cache:aresult mysql_query(mysql"SELECT COUNT(*) FROM `accounts`");
            
cache_get_field_content_int(0registeredmysql);
            
cache_delete(aresult);
            
format(stringsizeof(string), "{FFFF00}%s [%d] has successfully registered. [Total Accounts: %d]"pName(playerid), playeridregistered);
            
SendClientMessageToAll(yellowstring);
... 
But it shows "Player_Name [0] has successfully registered. [Total Accounts: 0]"
Why is it becomes 0? There are 3 rows in the table
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)