Hi,
Yeah, I did get it from a mysql_fetch_array(). I have:
ORDER BY
payment_methods.ba_type ASC,
loan_info.loan_number ASC
However, what it does is first orders it by ba_type, then it goes through
and re-orders it be loan_number, not keeping the ba_type order intact. I
would have much rather handled it all with the SQL, but it just doesn't seem
to work. Here's the entire query:
SELECT payment_methods.ba_type, loan_info.loan_number, loan_info.id AS
loan_id, cust_info.first_name, cust_info.last_name,
transactions.approved_date, payment_types.type FROM loan_info, cust_info,
transactions, payment_methods, payment_types WHERE payment_methods.id =
transactions.payment_method AND payment_types.id = transactions.trans_type
AND cust_info.id = loan_info.cust_id AND transactions.loan_id = loan_info.id
AND transactions.trans_type = 1 AND (transactions.approved_date >=
'2003-07-09 00:00:00' AND transactions.approved_date <= '2003-07-22
23:59:59') AND (loan_info.loan_number LIKE '101%' OR loan_info.loan_number
LIKE '136%' OR loan_info.loan_number LIKE '707%') GROUP BY loan_info.id
ORDER BY loan_info.loan_number ASC
Maybe I'm doing something wrong there?
-Dan Joseph
> -----Original Message-----
> From: Marek Kilimajer [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 22, 2003 11:25 AM
> To: Dan Joseph
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] Array Sorting, 2 items...
>
>
> 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;
> }
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
