GhostWD
I'm in love with the var_dump()
- Joined
- Jan 25, 2009
- Messages
- 185
- Solutions
- 6
- Reaction score
- 29
Hi OTLanders,
I've got problem with making query that returns items count for backpacks of id
what i need is getting pid of container, itemCount and correct itemtype
I've used
But it's not doing what i trully wan't
Thanks for help!
I've got problem with making query that returns items count for backpacks of id
what i need is getting pid of container, itemCount and correct itemtype
I've used
Code:
SELECT pid, COUNT(*)
FROM player_items
GROUP BY pid
HAVING pid in (SELECT DISTINCT pid FROM player_items WHERE player_id = 2 AND itemtype IN (1987,1988))
Thanks for help!
Last edited: