i'm not using a fixed sort

tnx  noam
  "Adam Voigt" <[EMAIL PROTECTED]> wrote in message 
  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 

The Cryptocomm Group
My GPG Key:

Reply via email to