Check for NULL values.
----- Original Message -----
From: "Ford, Mike [LSS]" <M.Ford@xxxxxxxxxxxxxx>
To: <kc68@xxxxxxxxxxx>; <php-db@xxxxxxxxxxxxx>
Sent: Thursday, March 04, 2004 12:55 PM
Subject: RE: Two Column Sort
> On 03 March 2004 17:07, kc68@xxxxxxxxxxx wrote:
>
> > I'm re-raising an issue I never quite resolved which has become more
> > critical. I want to sort a table on two columns. There are
> > about 440
> > rows of which about 400 are blank in the first sort column (CBC); the
> > other rows show B in that column. When I use the coding
> > below, the two
> > column sort takes place but the rows designated B are at the
> > bottom of the
> > (long) table and I want them at the top. Neither asc nor desc
> > accomplishes this (just reverses the second factor order,
> > still at the
> > bottom below the blanks).
> >
> > Here's the php code for the sort command:
> >
> > echo "<td><div align='center'><font size='3'><b>CBC <a
> > href='contributions22504.php?sort_field=cbc,
> > net_receipts&sort_order=desc'
> > target='_self'><font size='2'>Sort</a></b></font></div></td>\n";
> >
> > Here's the basic setup that begins the script:
> >
> > # get sort order (if any) passed to script
> > $sort_field = $_REQUEST['sort_field'];
> > if (! $sort_field) {$sort_field = "State";}
> > $sort_order = $_REQUEST['sort_order'];
> > if (! $sort_order) {$sort_order = "asc";}
>
> Well, your going to need an order phrase that looks like this:
>
> ORDER BY CBC DESC, NET_RECEIPTS ASC
>
> so you may need a little rethink about how you're passing those arguments.
>
> Cheers!
>
> Mike
>
> ---------------------------------------------------------------------
> 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
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
