When have many item, How to query?

[Mechomorph XD]

Hi If player use an item which have many each (because created from alchemist class). How could I do query stack into array?

e.g. Player have A's BOX 20 ea and B's BOX 12 ea.
I want to stack item id and amount in an array.
$@item_id[0] = 1000, $@card[0] = blah blah blah, $@amount[0] = 20
$@item_id[1] = 1000, $@card[0] = blah blah blah, $@amount[1] = 12

How to check it with sql query?

Thank You.

[deathscythe13]

can i see your table in sql?

[Mechomorph XD]

It's a inventory table. I'm doing NPC convert item to box but problem is if player have similar box (e.g. A's and B's Box) but each creator then player click B's Box which in inventory table B's Box info live bottom A's Box info, In Script sql will query A's Box info instead B's Box

How to check it?

I dont know about this, Thank You