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
And how would I find out which portion (row number) the row would be in,
that I would like to see in a listing?
Hello, how would I go about listing a portion of a MySQL table, without an
overall selection criterium? I have a unique index field, but it's a string
and not autoincremented (but ma
- 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 selectio
Hello, how would I go about listing a portion of a MySQL table, without an
overall selection criterium? I have a unique index field, but it's a string
and not autoincremented (but manually and with gaps). I just want to go to
one particular row (query on that index field) and then list, say, 20
5 matches
Mail list logo
