[KiLLeR.]

To show the skins in a menu, you don't have to play with player_weapons table, use only weapon_types or whatever you name it.

P.S. Or you want to show in that menu only the weapons that player own?

[TheWhitesmith]

Yeah that's it, I want to show the skins that the player owns.

[KiLLeR.]

-- First get the player id:
DECLARE @playerId = SELECT Id FROM players
WHERE SteamId = 'STEAM_:.....'

-- Get all skins which those player has:
SELECT * FROM player_weapons
INNER JOIN weapon_name ON weapon_name .Id = player_weapons.weaponId
WHERE player_weapons.playerId = @playerId

You need to have foreign keys between tables.

[TheWhitesmith]

This makes sense, I think pawn scripting stops here so I should go & learn about SQL commands.
Thank you for your help, really appreciate it!

[Airkish]

What about storing every skin in 1 column as string and explode() (not sure if it's called like that in AMXX) that string in plugin, so you can retrieve amount of certain skin player has

[klippy]

Originally Posted by Airkish What about storing every skin in 1 column as string and explode() (not sure if it's called like that in AMXX) that string in plugin, so you can retrieve amount of certain skin player has

No.

[aron9forever]

Originally Posted by Airkish What about storing every skin in 1 column as string and explode() (not sure if it's called like that in AMXX) that string in plugin, so you can retrieve amount of certain skin player has

this is even worse than what OP originally did

also, a JSON module has been added to amxx, so at least use that if you want to store aggregate data in a single cell; but please think it through because there are few scenarios where this is really the best solution

[Airkish]

Can you tell me why it's bad?
Because I have my skins stored like that and there's no issues

[aron9forever]

Originally Posted by Airkish Can you tell me why it's bad? Because I have my skins stored like that and there's no issues

I can, but I'd rather give an already written post by someone who knows much more about this than me
have a read here: https://stackoverflow.com/a/3653574/4478454