| |
 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 |
|
| |
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? |
|
|
