Inventory Quantity Problem

[nauir]

How would I make an inventory item to not print out twice?

 

My code works like this:

Select items where ownerid=1(loggedinuser)

If Item Name is already printed out once, stop printing that item and on the first item printed place x4(number in inventory).

 

For example:

I have 5 water bottles in my inventory. I want it to say, Water Bottle (x5).

[Maq]

I'm assuming this is a query...?

 

Try:

 

$query = "SELECT item, COUNT(ownerid) AS num FROM products GROUP BY item WHERE ownerid = 1";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
echo $row['item'] . "(x " . $row['num'] . ")
";
}

 

[nauir]

Thank-You very much! However, it didn't work until I switched around the where ownerid=1 and the group by

[Maq]

Thank-You very much! However, it didn't work until I switched around the where ownerid=1 and the group by

 

Oops