On Wed, 2003-02-19 at 11:14, Noam Giladi wrote:
i'm not using a fixed sort
"Adam Voigt" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
Assuming your sorting by id, just do:
SELECT TOP 50 * FROM TABLE WHERE id > $lastid
And just have lastid posting to the page every time
they hit next, and in lastid, put the last id of the results
on that page.
On Wed, 2003-02-19 at 09:59, Noam Giladi wrote:
I'm trying to split results into different pages and number the pages
accordingly. I've been able to build a fairly intelligent page numbering
system which knows which rows it should pull (at least by numbering each row
numerically) but I don't know how to construct a SQL query to pull 10
results starting at a certain number.
please did anyone wrote a proc that do it?.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Adam Voigt ([EMAIL PROTECTED])
The Cryptocomm Group
My GPG Key: http://220.127.116.11:8080/adam_at_cryptocomm.asc
-- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://18.104.22.168:8080/adam_at_cryptocomm.asc
Description: This is a digitally signed message part