[DarkLored]

What I meant is every time a player gets a gun a row is created for him with his ID, maximum rows are two for each player, now if the player has two existing rows for himself I am trying to figure out how to get the two rows separately and then putting them into two separate rows.

I'll show you my table itself

pawn Код:

strcat(Query, "CREATE TABLE IF NOT EXISTS `Weapons` (`ID` INTEGER DEFAULT 0 NOT NULL, `Weapon` INTEGER DEFAULT 0 NOT NULL, `Ammo` INTEGER DEFAULT 0 NOT NULL, FOREIGN KEY(`ID`) REFERENCES `Users`(`UserID`) ON UPDATE CASCADE ON DELETE CASCADE);", sizeof(Query));