scroll through records.

Hi,

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
1 record1
2 record2
3 record3
4 record4
5 record5
6 record6
7 record7
8 record8

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?

Vince

is this
"moving from the 1,2,3,4,5 state to the 2,3,4,5,6 state"
done by a next button
or
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
?

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