[SOLVED] Display one mysql_row

[fighnight]

I am having this trouble, I am trying to make an list of how many stuff someone has but I am having this error it shows two rows

 

Like

 

Item Here                Amount

 

Baseball Bat              2

 

Baseball Bat              2

 

 

I am trying to make it only display one but I can't figure it out. :[

[thomashw]

Can you post the code you're using?

 

I'd say you should use a loop with a $counter variable.

[fighnight]

 

<tr><td> Item </td> <td> Amount </td> </tr>
$item_info= mysql_query("SELECT * FROM item WHERE owner='1'");

while($iteminfo= mysql_fetch_array($item_info)
{
$result1 = mysql_query("SELECT * FROM item WHERE item = '$iteminfo[item]'");

$idu=mysql_num_rows($result1);
echo "<tr><td>$iteminfo[item]</td><td>$idu</td></tr>";
}

 

Very Weird but ehh....

 

[thomashw]

Are you just trying to display how many items are in the item table under that owner?

 

<?
echo '<tr><td>Item Amount</td></tr>
$query = ("SELECT * FROM item WHERE owner='1'");
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);
echo $num_rows;
?>

 

Or, is there only one item under the owners name, but it's displaying it twice? Or are there two items, but you only want the first displayed?

[fighnight]

I am doing this.

 

The owner can own 2 or more of the items and my error is showing both. I want it to show only one.

 

 

[robotman321]

the while is a loop, it picks everything out that: WHERE owner='1' it means it will keep going no matter what the person.  I.e. it will go for a user name fred that is an owner if they own 2 items it will pull that one item once then pull the next item for that user.

 

your statement is only for pulling one item at a time no matter the user.

[thomashw]

Try this:

 

<tr><td>Item Amount</td></tr>
<?
$query = ("SELECT * FROM item WHERE owner='1'");
$result = mysql_query($query);
for($count=0; $count<1; ++$count)  {
while($iteminfo = mysql_fetch_assoc($result)) {

echo "<tr><td>$iteminfo[item]</td><td>$idu</td></tr>";
}}
?>

[rajivgonsalves]

your code should be I've simplified some things

 

<tr><td> Item </td> <td> Amount </td> </tr>
$item_info= mysql_query("SELECT count(*) as count,item FROM item WHERE owner='1' group by item");

while($iteminfo= mysql_fetch_array($item_info)
{
echo "<tr><td>{$iteminfo['item']}</td><td>{$iteminfo['count']}</td></tr>";
}

 

tell me if it works!!!

[fighnight]

rajivgonsalves thank you. Your code made it work. Thank you.