Arrays aren't fun!?

tommmmm

First off I should say that I'm quite new to arrays, been working with PHP for a while but generally avoided arrays of a multi-dimmensional type.

I have an array like,

Array
(
    [0] => Array
        (
            [ID] => 78
            [TYPE] => teacher
            [DATE] => 2007-05-19 19:51:00
            [TITLE] => jon
        )

[1] => Array
    (
        [ID] => 37
        [TYPE] => link
        [DATE] => 2007-05-13 18:12:26
        [TITLE] => fff
    )

[2] => Array
    (
        [ID] => 77
        [TYPE] => event
        [DATE] => 2007-05-13 18:07:46
        [TITLE] => Start-Time
    )
)

etc

I want to sort the entire array by the date field, so the whole array is in date order. The actual array is a lot larger than this, but it repeats in the same way. I've looked into the multisort function. Is this the right function to be looking at or is there a better way to do this?

Thanks,
Tom

Piranha

How do you get the values to the array? I am asking because if you use a database it is much better to sort in the database.

tommmmm

The values come from a database, but from several different tables. I'm basically looking to create a view of the recent activity on the database.

Currently I query a table, add the values to the array. Then do another table..rince repeat to create the array.

Is there perhaps a way to do this?

Piranha

First I have to say that it seems like the database is poorly designed if the same information is stored in several tables. I recommend redesigning the database if possible.

Second you should still use the database. Use union to union the results from several tables.

bradgrafelman

If you can show us the database design, we might be able to suggest a better structure to ease queries like you're doing now.

Alternatively, you'd have to use [man]array_multisort/man.