PHP - 通过id聚合数组

Question

i have data like this

id       color  
102      blue  
102      red  
102      pink  
114      green  
114      red
114      yellow  
114      gray  
118      white  
118      blue  

i want agglomerate color by id.. and i want result like this:

Array
(
    [0] => Array
        (
            [0] => blue
            [1] => red
            [2] => pink
        )

    [1] => Array
        (
            [0] => green
            [1] => red
            [2] => yellow
            [3] => gray
        )

    [2] => Array
        (
            [0] => white 
            [1] => blue
        )

)

how i make it.. i'm still newbie, i'm little confusing make it

Answer 1

You can do like this:

unset($array);
$array = array(
0 => array("id"=>102,"color"=>"blue"),
1 => array("id"=>102,"color"=>"red"),
2 => array("id"=>102,"color"=>"pink"),
3 => array("id"=>114,"color"=>"green"),
4 => array("id"=>114,"color"=>"red"),
5 => array("id"=>114,"color"=>"yellow"),
6 => array("id"=>114,"color"=>"gray"),
7 => array("id"=>118,"color"=>"white"),
8 => array("id"=>118,"color"=>"blue")
);

unset($output);
if (is_array($array) && count($array) > 0) {
   foreach ($array as $value) {
      $output[$value["id"]][] = $value["color"];
   }
}
//[EDIT] ADD this:
$output=array_values($output);