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
2 matches
Mail list logo
