simple db query situation

[Dirty-Rockstar]

im building one of those endless fun text based games Its more of a hobby to learn php. heres my situation

I have a table called players which house many things including playerID

 

i want to make another table called items, then when items are inserted i want to display items belonging to playerID. question is how do i connect the 2 of them. do i insert playerID into the item table on signup so i can use this?

 

$id=$_SESSION['playerID'];

$item1="SELECT * FROM items WHERE playerID='$id'";
$item2=mysql_query($item1) or die(mysql_error());
$item3=mysql_fetch_array($item2);

print "$item3[itemnamehere]";

or is there an easier answer to query both tables. or will i have to use this method. this is my first experience in 2 tables

[Dirty-Rockstar]

hrmm im thinking on doing it this way. 2 item tables

 

1 table to house the unique id of an item/name and information about the item and a second table housing the player ID and amount that the user has.

 

im going to try that one = )

[lemmin]

If you do that way, why not just have a column that holds a set of items that the player has in the player table?