Combine two array and order this new array by date

Question

. I have two array

First One

 Array
    (
        [0] => Array
            (
                [date] => 2012-01-10
                [result] => 65
                [name] => Les océans
            )

        [1] => Array
            (
                [date] => 2012-01-11
                [result] => 75
                [name] => Les mers
            )

        [2] => Array
            (
                [date] => 2012-01-13
                [result] => 66
                [name] => Les continents
                [type] => Scores
            )

    )

The second

Array
(
    [0] => Array
        (
            [date_end] => 2012-01-12
            [result] => 60
            [name] => Step#1
            [type] => Summary
        )

)

And I want this for my final result

 Array
        (
            [0] => Array
                (
                    [date] => 2012-01-10
                    [result] => 65
                    [name] => Les océans
                )

            [1] => Array
                (
                    [date] => 2012-01-11
                    [result] => 75
                    [name] => Les mers
                )

             [2] => Array
            (
                [date_end] => 2012-01-12
                [result] => 60
                [name] => Step#1
                [type] => Summary
            )

            [3] => Array
                (
                    [date] => 2012-01-13
                    [result] => 66
                    [name] => Les continents
                    [type] => Scores
                )

        )

So .... I need to combine my first array with the second and I want to order this new array by date !... Can someone can help me on hint me for doing this ? Thx !

Answer 1

array_merge and usort is your friend.

function cmp($a, $b){
    $ad = strtotime($a['date']);
    $bd = strtotime($b['date']);
    return ($ad-$bd);
}
$arr = array_merge($array1, $array2);
usort($arr, 'cmp');

Answer 2

Use array_merge() to combine the arrays, and then use sort to sort() to sort them, very simple. Would you like an example?

This should sort it for you:

function dateSort($a,$b){
    $dateA = strtotime($a['date']);
    $dateB = strtotime($b['date']);
    return ($dateA-$dateB);
}

$arrayOne = array(
    array(
        'date'      => '2012-01-10',
        'result '   => 65,
        'name'      => 'Les océans'
    ),
    array(
        'date'      => '2012-01-11',
        'result '   => 75,
        'name'      => 'Les mers'
    ),
    array(
        'date'      => '2012-01-13',
        'result '   => 66,
        'name'      => 'Les continents',
        'type'      => 'Scores'
    )
);

$arrayTwo = array(
    array(
        'date'      => '2012-01-12',
        'result '   => 60,
        'name'      => 'Step#1',
        'type'      => 'Summary'
    )
);

// Merge the arrays
$combinedArray = array_merge($arrayOne,$arrayTwo);

// Sort the array using the call back function
usort($combinedArray, 'dateSort');