multi d array - desired output format

[is_numeric]

Hi Guys

 

i have a multi d array

 

Array
(
    [0] => Array
        (
            [fi_menu_id] => 1
            [fi_sub_menu_name] => Cavity Wall & Loft Insulation
            [fi_menu_name] => Insulation
            [fi_menu_order] => 1
        )

    [1] => Array
        (
            [fi_menu_id] => 1
            [fi_sub_menu_name] => External Wall Insulation
            [fi_menu_name] => Insulation
            [fi_menu_order] => 1
        )

    [2] => Array
        (
            [fi_menu_id] => 1
            [fi_sub_menu_name] => Pipe & Tank Insulation
            [fi_menu_name] => Insulation
            [fi_menu_order] => 1
        )

    [3] => Array
        (
            [fi_menu_id] => 1
            [fi_sub_menu_name] => Tools & Equipment
            [fi_menu_name] => Insulation
            [fi_menu_order] => 1
        )

    [4] => Array
        (
            [fi_menu_id] => 1
            [fi_sub_menu_name] => Machine Equipment & Spares
            [fi_menu_name] => Insulation
            [fi_menu_order] => 1
        )

    [5] => Array
        (
            [fi_menu_id] => 2
            [fi_sub_menu_name] => Electrical & Lighting 
            [fi_menu_name] => Tools & Equipment
            [fi_menu_order] => 2
        )

    [6] => Array
        (
            [fi_menu_id] => 2
            [fi_sub_menu_name] => Security Equipment 
            [fi_menu_name] => Tools & Equipment
            [fi_menu_order] => 2
        )

    [7] => Array
        (
            [fi_menu_id] => 2
            [fi_sub_menu_name] => Surveying Equipment
            [fi_menu_name] => Tools & Equipment
            [fi_menu_order] => 2
        )

    [8] => Array
        (
            [fi_menu_id] => 2
            [fi_sub_menu_name] => Ventilation Equipment
            [fi_menu_name] => Tools & Equipment
            [fi_menu_order] => 2
        )

    [9] => Array
        (
            [fi_menu_id] => 2
            [fi_sub_menu_name] => Power Tools & Drills
            [fi_menu_name] => Tools & Equipment
            [fi_menu_order] => 2
        )

    [10] => Array
        (
            [fi_menu_id] => 3
            [fi_sub_menu_name] => 
            [fi_menu_name] => Draught Proofing
            [fi_menu_order] => 3
        )

    [11] => Array
        (
            [fi_menu_id] => 4
            [fi_sub_menu_name] => 
            [fi_menu_name] => Saftey Workwear
            [fi_menu_order] => 4
        )

    [12] => Array
        (
            [fi_menu_id] => 5
            [fi_sub_menu_name] => 
            [fi_menu_name] => Ancillaries & Consumables
            [fi_menu_order] => 8
        )

    [13] => Array
        (
            [fi_menu_id] => 6
            [fi_sub_menu_name] => 
            [fi_menu_name] => Building Products
            [fi_menu_order] => 5
        )

    [14] => Array
        (
            [fi_menu_id] => 7
            [fi_sub_menu_name] => 
            [fi_menu_name] => Miscellaneous 
            [fi_menu_order] => 6
        )

    [15] => Array
        (
            [fi_menu_id] => 8
            [fi_sub_menu_name] => 
            [fi_menu_name] => Terms & Conditions
            [fi_menu_order] => 7
        )

)

 

what i am trying to do is create a menu->submenu

 

[fi_menu_name] key feeds the menu

 

[fi_sub_menu_name] feeds the sub menu

 

what i need is to create an array from the code above into this format...

 

Array
(
    [insulation] => Array
        (
            [0] => Cavity Wall & Loft Insulation
            [1] => External Wall Insulation
            [2] => Pipe & Tank Insulation
            [3] => Machine Equipment & Spares
        )
  [Tools & Equipment] => Array
        (
            [0] => Electrical & Lighting 
            [1] => Ventilation Equipment
            [2] =>  Surveying Equipment
        )

  [Draught Proofing] => Array
        (
           
        )

 

 

as you can see the main menu value is the key and the sub menu is the values

 

i have gone code blind looking at this

 

can anyone help

 

 

 

 

 

 

 

 

[thebadbad]

Try

 

<?php
//$array is your original array
$newarr = array();
foreach ($array as $subarr) {
$key = $subarr['fi_menu_name'];
$newarr[$key][] = $subarr['fi_sub_menu_name'];
}
echo '<pre>', print_r($newarr, true), '</pre>';
?>

[is_numeric]

thanks

 

i had double the lines and still wasnt working.

 

i was over engineering it out of frustration

 

Respect!