[RESOLVED] sorting complec(?) arrays

[sgray]

Hey guys,

I was hoping you could help me with a little problem I'm having sorting array of arrays. I have a data structure which looks like the following:

r_print($shows);

(
    [Bored to death] => Array
        (
            [current_episode] => 1x07
            [current_name] => The Case of the Stolen Sperm
            [current_date] => Nov/01/2009
            [current_screened] => 6.9
        )

[Californication] => Array
    (
        [current_episode] => 3x06
        [current_name] => Glass Houses
        [current_date] => Nov/01/2009
        [current_screened] => 6.9
    )

[Cougar Town] => Array
    (
        [current_episode] => 1x07
        [current_name] => Don't Come Around Here No More
        [current_date] => Nov/04/2009
        [current_screened] => 3.9
    )
)

I'm wanting to write a loop which prints out the info, in a sorted order based on the 'current_screened' value, which shows how long ago the show screened. I looked at plenty of examples of sorting multidimensional & associative arrays but I cant seem to apply any of them to the data structure I have used (by the way, does it look an alright way of storing this data, or is there a better way?).

Any help would be greatly appreciated

[sgray]

By the way, I have been using this to list them, unsorted...

foreach ($shows as $current_show=>$value) {
echo "".$shows[$current_show]["current_episode"]." - ".$shows[$current_show]["current_name"]."";
}

It seems a bit icky..

[dagon]

looks like its coming from a db, so why not use the db sort functions

assuming mysql..

select * from shows ORDER BY current_screened

[sgray]

thanks, It's not actually coming from a db though. I'm scraping the data from an XML feed. I actually considered putting in a mysql table so I could suck it out again, but it seems a little convoluted.

[Weedpacket]

[man]uksort[/man]

function compare_by_current_screened($a, $b)
{
    return $a['current_screened'] - $b['current_screened'];
}

[sgray]

seems it's sorting them with that function and uksort, but it's definitely not by current_screened.

Almost seems random now...

[Nip Tuck] => Array
	(
		[current_episode] => 6x04
		[current_name] => Jenny Juggs
		[current_date] => Nov/04/2009
		[current_screened] => 4.9
	)

[Glee] => Array
	(
		[current_episode] => 1x08
		[current_name] => Mash-Up
		[current_date] => Oct/21/2009
		[current_screened] => 18.9
	)

[Californication] => Array
	(
		[current_episode] => 3x07
		[current_name] => So Here's The Thing ...
		[current_date] => Nov/08/2009
		[current_screened] => 0.9
	)

[bpat1434]

Perhaps Weedpacket meant [man]uasort/man

[sgray]

perhaps he did! Works perfect 🙂

Thanks all.

[Weedpacket]

Uh, yeah; um, the keys are like right next to each other, that must be it. Or something.