[Vince]

PHP код:

SELECT foo FROM bar LIMIT 0, 8 


Where 0 is the row index you want to start from, and 8 is the number of rows you want to fetch. The next queries will then be:
8,8
16,8
24,8
32,8
etc

Of course easily calculated by doing page * 8.