too long

Question

i have an array:

Array
(
    [users] => Array
        (
            [101] => Array
                (
                    [odata] => Array
                        (
                            [0] => 2
                            [1] => 1
                            [2] => 1
                            [3] => 1
                        )

                )

            [200] => Array
                (
                    [odata] => Array
                        (
                            [0] => 2
                            [1] => 1
                            [2] => 1
                            [3] => 0
                        )

                )

        )

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

        )

)

in this array [rjad] key = [odata] key, and [odata] value = second key in [rjad].

What i want is to create new array from old one with user ids values in second array:

like this:

[rjad] => Array
            (
                [2] => Array
                    (
                        [0] => red
                        [1] => Array
                                   (
                                     [blue] => Array
                                               (
                                                 [0] => 101
                                                 [1] => 200
                                                )
                        [2] => green
                    )

            )

Struggling already 3 hours with no success. Any ideas how to get it are very wellcome.

Image do explain relatinships http://imageshack.us/photo/my-images/818/phparray.jpg/

Answer 1

I'd seriously rethink your structure, but here's a working (if ugly) solution

foreach ($users as $userId => $user) {
    foreach ($user['odata'] as $key => $value) {
        if (isset($rjad[$key][$value])) {
            if (!is_array($rjad[$key][$value])) {
                $colour = $rjad[$key][$value];
                $rjad[$key][$value] = array();
                $rjad[$key][$value][$colour] = array();
            } else {
                reset($rjad[$key][$value]);
                $colour = key($rjad[$key][$value]);
            }
            $rjad[$key][$value][$colour][] = $userId;
        } 
    }
}

Working demo -> http://codepad.viper-7.com/IEcpvU

Based on comments seems you may want a separate array, which is easily solved

// copy the array and act on it instead of directly on $rjad
$result = $rjad;
foreach ($users as $userId => $user) {
    foreach ($user['odata'] as $key => $value) {
        if (isset($result[$key][$value])) {
            if (!is_array($result[$key][$value])) {
                $colour = $result[$key][$value];
                $result[$key][$value] = array();
                $result[$key][$value][$colour] = array();
            } else {
                reset($result[$key][$value]);
                $colour = key($result[$key][$value]);
            }
            $result[$key][$value][$colour][] = $userId;
        } 
    }
}