Welcome Guest, Not a member yet? Register   Sign In
MySql query and array help needed. This ones a bit harder I think
#1

[eluser]megabyte[/eluser]
Here's my result

Code:
Array
(
    [0] => Array
        (
            [id] => 1
            [parent_id] => 0
            [name] => Fruit
        )

    [1] => Array
        (
            [id] => 4
            [parent_id] => 0
            [name] => Vegetables
        )

    [2] => Array
        (
            [id] => 6
            [parent_id] => 0
            [name] => Ketchup Chips
        )

    [3] => Array
        (
            [id] => 7
            [parent_id] => 6
            [name] => BBQ Chips
        )

)


I want to make it look like this by traversing through the array and if the parent_id != 0 add it to the corresponding array like so.

Code:
Array
(
    [0] => Array
        (
            [id] => 1
            [parent_id] => 0
            [name] => Fruit
        )

    [1] => Array
        (
            [id] => 4
            [parent_id] => 0
            [name] => Vegetables
        )

    [2] => Array
        (
            [id] => 6
            [parent_id] => 0
            [name] => => Array
                    (
                         [id] => 7
                         [parent_id] => 6
                         [name] => BBQ Chips
                    )
        )

)


notice how it becomes a multi dimentional array.

Thanks in advance.




Theme © iAndrew 2016 - Forum software by © MyBB