Re: Array Sorting, 2 items...

From: Date: Tue, 22 Jul 2003 15:25:21 +0000
Subject: Re: Array Sorting, 2 items...
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-156238@lists.php.net to get a copy of this message
Your array seems like a result of mysql_fetch_array(), cannot you order it in the sql query? Dan Joseph wrote:
Array (
    [0] => Array
        (
            [0] => CHECKING
            [ba_type] => CHECKING
            [1] => 10132200
            [loan_number] => 10132200
Keep everything groupped together in their respective ba_type, and put the numbers in numeric order. I've looked at usort, and many examples of it. I can see how to use it to sort one column, but how would I sort a second to achieve this? Simply if ba_types are equal, continue with checking loan_numbers:
function cmp ($a, $b) {
    if ($a['ba_type'] == $b['ba_type']) {
if ($a['loan_number'] == $b['loan_number']) return 0;
         return ($a['loan_number'] > $b['loan_number']) ? -1 : 1;
    }
    return ($a['ba_type'] > $b['ba_type']) ? -1 : 1;
}

« previous php.general (#156238) next »