* Thus wrote Dan Joseph ([EMAIL PROTECTED]): > Eek... Yes, I did past it wrong... > > 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 payment_methods.ba_type ASC, loan_info.loan_number ASC > > That's the right query. Anything wrong with that? Shouldn't that give me > the sort I'm looking for without having to do a usort?
Correct, that should sort properly. If that isn't workin I would get on the database servers mailing list (if they have one). Curt -- "I used to think I was indecisive, but now I'm not so sure." -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
