Re: [PHP-DB] Two Column Sort

2004-03-05 Thread kc68
On Fri, 5 Mar 2004 15:59:47 -, 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 understand

RE: [PHP-DB] Two Column Sort

2004-03-05 Thread Ford, Mike [LSS]
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).

RE: [PHP-DB] Two Column Sort

2004-03-05 Thread Ford, Mike [LSS]
On 04 March 2004 19:04, [EMAIL PROTECTED] wrote: > On Thu, 4 Mar 2004 10:55:20 -, Ford, Mike [LSS] > <[EMAIL PROTECTED]> wrote: > > > On 03 March 2004 17:07, [EMAIL PROTECTED] wrote: > > > > > Here's the php code for the sort command: > > > > > > echo "CBC > > href='contribut

Re: [PHP-DB] Two Column Sort

2004-03-04 Thread kc68
On Thu, 4 Mar 2004 10:55:20 -, Ford, Mike [LSS] <[EMAIL PROTECTED]> wrote: On 03 March 2004 17:07, [EMAIL PROTECTED] 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

Re: [PHP-DB] Two Column Sort

2004-03-04 Thread Viorel Dragomir
Check for NULL values. - Original Message - From: "Ford, Mike [LSS]" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, March 04, 2004 12:55 PM Subject: RE: [PHP-DB] Two Column Sort > On 03 March 2004 17:07, [EMAIL PROTECTED]

RE: [PHP-DB] Two Column Sort

2004-03-04 Thread Ford, Mike [LSS]
On 03 March 2004 17:07, [EMAIL PROTECTED] 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 col

[PHP-DB] Two Column Sort

2004-03-03 Thread kc68
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 t