Display results in a 4x2 display (4 columns, 2 rows) WITH pagination

Ok, this one is tricky (for me anyways, one of you guys probably knows this and can do it in your sleep) What I am trying to do is display the results of a mysql query with 8 items on a page and in the following format:

------------------------------------------------------------
|  first data  |  second data  |    third data     |  fourth data  |
-------------------------------------------------------------
|  fifth data  |   sixth data    |  seventh data  |  eigth data    |
-------------------------------------------------------------
                      <- previous page | next page ->

Now I know how to put query data into columns, and I know how to paginate query data, but they seem to conflict combining them, since they both effect the query itself, sort of driving the query.

[Join us @ facebook]

Can you give a part of your code?

[Free WordPress Themes]

something like this?
http://www.finalwebsites.com/demos/php_mysql_nested_repeat_region.php

you can use this together with this snippet:
http://www.finalwebsites.com/snippets.php?id=37

but next you shpuld show us you page we don't provide the solution because you're just asking

[Guest]

[36.084]

Googlebot, Yahoo crawler, YMC, Baidu Spider