Inventory page help

sumday

I have two mysql tables:

One is called items and it looks like this:

Name
Potion

The other is called inventory and it looks like this.

Username | Potion
anybody | 2

How could I make a php script that outputs all of the items that $Username has and how many of each item?

If you would like me to explain more just ask.

eriksmoen

$q1 = mysql_query("select `Name`,`Potion` from items where `Name` = '$username' group by `Potion`");
while($r1 = mysql_fetch_array($q1)){
   $potion = $r1['Potion'];
   $r2 = mysql_fetch_array(mysql_query("select count(*) from inventory where `Name` = '$username' and `Potion` = '$potion'"));
   echo "$potion (x".$r2[0].")<BR>";
}

hope that's what you were looking for and that it helps.

sumday

Yes but say I have another item in there later. I don't want to have to change the code to print every item ad how much of it there is. I hope that made sense.

sumday

can somebody help i need to get this done quick.

eriksmoen

that will pull every potion that that username has... included new ones.

sumday

every item means every item.....

not every potion..

I might need more items than a potion later in the game.

You might want to read a little better.

eriksmoen

Well I'm sorry... I will have to remember from now on that it's a waste of time trying to help you... since, you know, I can't read. I suppose maybe that's why no one else bothered posting in here.