• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

PHP Get count players storage

Kahras

Member
Joined
Aug 6, 2012
Messages
101
Reaction score
7
Location
Warsaw
I need a mysql query that will return me the number of players who have storage 5000 == 1
Can anyone help?
 
👀

SQL:
SELECT COUNT(`player_id`) FROM `player_storage` WHERE `key` = 5000 AND `value` = 1;
 
Something like that?
Lua:
SELECT COUNT(`key`) FROM `player_storage` WHERE `key` = '5000' AND `value` = 1

edit:
use code of Roddet :'/ is better
 
Last edited:
Back
Top