grouping multidimensional array

[webnick]

Hi, I have a 3D array that I'm trying to traverse and wondering the best way to group results? The query returns

category | item | note
3 | 1200 | socks
3 | 1440 | stockings
8 | 400 | wool hat

How can I group these?

while($row = mysql_fetch_assoc($result)) 
{
		$this_fund = $row['category'];
		if($this_fund != $row['category'])
		{
				echo "\n $this_fund";
				$this_fund = $row['category'];
		}
}

Or build a tough array?

[NogDog]

Can you give us a clearer explanation of what it is you want to do? It's not clear to me what you mean when you say you want to "group results".

[Protato]

Are you trying to group them by the category in an array?

<?
//get result set.
while($row = mysql_fetch_array($result)){

   //add each item_id to the array in corresponding category.
   $this_fund[$row['category_id']][] = $row['item_id'];
}


//you could then cycle through your results, and print them by  the grouping.
foreach($this_fund as $category_id => $item_key){

   echo "Cateogry ".$category_id."<br />";

   foreach($this_fund[$category_id] as $item_key => $item_id){
      echo $item_id."<br />";
   }

   echo "<br />";

}

?>

That what you're looking for?