array sorting

[rr_pilot]

ok heres what my problem is, i have a array created from a file which acts like a db and in the array it has each line of the text database like this:

field1<~>field1<~>January 1, 2001

ok each field as u can see is seperated by <~> and i need to sort this array by the date, can someone please help? if u can solve our problem u will get reconition at our site for this script.

[Anon]

It would be a lot easier if the date was stored as a timestamp or in YYYYMMDD format. Then a simple strrchr/strcmp call could be used in a usort function.

[kelvinsun]

Try this out!

<?
function compare($a,$b) {
list($x,$y,$a_date) = split("<~>",$a);
list($x,$y,$b_date) = split("<~>",$b);
return (strtotime($a_date) > strtotime($b_date));
}

$test = array("fieldA<~>fieldB<~>March 1, 2001","fieldA<~>fieldB<~>January 3, 2001","fieldA<~>fieldB<~>January 2, 2001");

usort($test, "compare");

foreach ($test as $t){
echo "$t<BR>";
}
?>

[rr_pilot]

SWEEET! you are a life saver!