Logo

    Home    |    New Thread
Message
    writing db results to multiple pages
Author
 shiaislamasp
Date
 01/04/2001 7:56 PM
how do i write say 10 db results, from a select statement, on a page, then link to another page, with the next 10, and so on..
I would be very grateful for any help
Thank you

Responses
   RE: writing db results to multiple pages
Author
 adom
Date
 01/05/2001 3:33 AM
Asuming your database is sorted by a incrementing value you can use the BETWEEN statement in your querry.
That is on the first page you do:
SELECT * from Table WHERE OrderValue BETWEEN 1 and 10
Then you pass along the last value to the next page ""show_rewults?start=11"" for example and go from there
SELECT * from Table WHERE OrderValue BETWEEN 11 and 20
and so on?


Copyright © 2003-2008 YesSoftware All Rights Reserved.