On 05 March 2004 14:49, Ken Colburn wrote:That did it, Mike, with a slight change to make receipts descend. Thanks again.
Mike -
I've tried your options and I get either an error message, no sorting, or sorting that does not do both columns with B's at the top. It's my understanding that I must still use sort_field and sort_order (though I tried just ORDER BY). It does seem simple, but nothing works. It would be a great help if you could plug something (anything) into the url that works at http://congress.techpolitics.org/contributions22504.php/ Hope this isn't asking too much.
Right, this is what I plugged in that I think gives the result you're asking
for:
http://congress.techpolitics.org/contributions22504.php?sort_field=cbc%20des c,%20net_receipts&sort_order=asc
I've had to contrive the parameters a bit to work around the way you're processing them, but hopefully you get the idea.
Just to over-egg the pudding a bit, I thought I'd extend the idea slightly
and give you one more example:
http://congress.techpolitics.org/contributions22504.php?sort_field=cbc%20des c,state%20asc,%20net_receipts&sort_order=desc
Cheers!
Mike
P.S. please keep the discussion on the list so others can chip in if they want -- and any final resolution gets into the list archives for anyone reading the thread in the future.
Ken
--------------------------------------------------------------------- Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning & Information Services, JG125, James Graham Building, Leeds Metropolitan University, Beckett Park, LEEDS, LS6 3QS, United Kingdom Email: m.ford@xxxxxxxxxxxxxx Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
