February 18th, 2003, 04:29 PM
scroll through records.
This one is kinda hard to explain.
I need to scroll though the records of a database table 5 at a time.
For example, I have ten records
I want to display records 1,2,3,4 and 5, then the next time the page is hit, display 2,3,4,5,6, next time 3,4,5,6,7, then 4,5,6,7,8, and then it revolves around to the first one displaying 5,6,7,8,1.
I have wrote an elaborate PHP script that does this but it takes too long to load it. Is there a sql statement that might do it?
February 19th, 2003, 04:06 AM
"moving from the 1,2,3,4,5 state to the 2,3,4,5,6 state"
done by a next button
if I visit the page I see 1,2,3,4,5 and right after me John Smith visits the page sees the 2,3,4,5,6
February 19th, 2003, 09:00 AM
The latter, if I visit the page I see 1,2,3,4,5 and right after me John Smith visits the page sees the 2,3,4,5,6