GROUP BY - php,mysql

[ryza_]

How come when i use GROUP BY in mysql select statement it only returns 1 result?

i want to return a specified amount and group by specific items.

ex. 5 items of this, 5 items of that, etc.

any suggestions..

thanks.

<?
$result = mysql_query("SELECT SQL_CALC_FOUND_ROWS item_id,COUNT(item_id),item_name FROM data WHERE object LIKE '$inputted' group by item_id order by item_name") or die(mysql_error());

$number=mysql_query("SELECT FOUND_ROWS()");
list($total) = mysql_fetch_array($number);
if($total>="1"){
	for($i=0; $i<$total; $i++){
		$row = mysql_fetch_row($result) or die(mysql_error());
		$item_id=$row[0];
		$item_name=$row[2];
		print "$item_id/$item_name<BR>\n";
	}
}
?>

[The_Chancer]

A couple of changes to try...

<?
$result = mysql_query("SELECT SQL_CALC_FOUND_ROWS item_id,COUNT(item_id) as quantity,item_name FROM data WHERE object LIKE '".$inputted."' group by item_id order by item_name") or die(mysql_error());

$number=mysql_query("SELECT FOUND_ROWS()");
list($total) = mysql_fetch_array($number);
if($total>="1"){
    for($i=0; $i<$total; $i++){
        $row = mysql_fetch_row($result) or die(mysql_error());
        $item_id=$row[0];
        $item_name=$row[2];
        print "$item_id/$item_name<BR>\n";
    }
}
?>