Simply do it like with math fields:
SELECT count(*) WHERE order_column < '$mid_row_value'
Marco Bleeker wrote:
At 15:38 20-11-02 +0100, you wrote:
I don't think this can be done without ordering the selection first.
Then you can do it:
1. you need to find out the value your middle row has in
I don't think this can be done without ordering the selection first.
Then you can do it:
1. you need to find out the value your middle row has in the order column,
2. count rows with smaller value in the order column than your middle
row, this is its offset
3. now you can (using the offset) selec
- Original Message -
From: "Marco Bleeker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 19, 2002 8:34 PM
Subject: [PHP] Listing a table
> Hello, how would I go about listing a portion of a MySQL table, without an
> overall selection criterium? I have a unique index
3 matches
Mail list logo
