php/mysql game help

[Rifts]

hey everyone

to keep it simple, im trying to make a game and can not figure out how to set up the database for the items

say there are 10 items to keep it simple

 

here is what i came up with but what do i do to track if a player has more than one of the same item so if someone has 3x soild gold bars?

 

thanks for the help

 

 

Item Name         Price   Array Name Image Name      

 

Copper lock pick   10   copperpick      copperpick.jpg

Solid gold bar           20   solidgold   solidgold.jpg

iron lock pick           20   ironpick   ironpick.jpg

Fine mythral pick   30      mythralpick      mythralpick.jpg

Rare magic lock pick  4000  nullmagicpick  nullmagicpick.jpg

Shopowner’s deed   400    shopdeed   shopdeed.jpg

 

[xoligy]

Items table:

Id | Item | Price | Img

 

Useritems

Id | Item_id | User_id | Qty

 

So you have the items in one table and then when the user buys an item its added to the useritems table so if user brough 5x solidy gold bar in user items it would be inserted in user items as

 

id: normally as a key auto increm

item id: 2

user id: whatever there user id is (i use there id number)

qty: 5

 

You then link it to the purchase screen. Hope that makes sense

[Rifts]

that does help ill will work on this

 

thanks a bunch

[Rifts]

i just got done creating a database which follows what you said but i got to thinking about i dont understand how this will work when more than one person gets the item

 

will the database just be full of stuff like this

 

Id | Item_id | User_id | Qty

 

1  1    1245324    3

2  2    1245324    4

 

and then if someone else has the same item there will be another entry for that user too right

 

is it possible to have to much in a database? or is it ok for example lets pretend i get 1000 users and they each have 5 items

that will be 5000 different entries into this database is that ok?