On Fri, 5 Mar 2004 15:59:47 -0000, Ford, Mike [LSS] <[EMAIL PROTECTED]> wrote:

On 05 March 2004 14:49, Ken Colburn wrote:

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
works.  It would
be a great help if you could plug something (anything) into
the url that
works at
Hope this isn't
asking too much.

Right, this is what I plugged in that I think gives the result you're asking

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



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.

That did it, Mike, with a slight change to make receipts descend. Thanks again.


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
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

Reply via email to