MySqli Vertical Repeating Region

Hi
I have a list of over 100 names which I would like to put in 4 alphabetically ordered columns using the last name.
It is pretty easy to make a horizontal repeating region with the MySqli SBs.

Such as:

A B C D
E F G H

However, is it possible to do this vertically?

A E I
B F J
C G K
D H L

etc.

It does not seem natural to view these names listed in horizontal rows especially if one includes the first and middle names as well..

An alternative work around would be to have 4 (or more) Recordsets and separate corresponding repeating regions but some additional code
would have to be inserted into each Recordset showing only records 1-25, 26-50. 51-75, 76-100, etc.
I am not sure how to do this either.

Thanks for any advice.

The way to do it is to get the number of records from the recordset and put the results into four divs that use css for: float:left; width:25%.

You would have to check the position in the recrord and write a new div when every 1/4 of the way through the results.

Thanks Ray,

I did just that. For those interested in the solution, I created 4 different recordsets using the "limit clause" to select the desired records for each column and then displayed these vertically with corresponding repeating regions in separate divs


rsName1

"SELECT * FROM names ORDER BY last_name ASC limit 25, "

displays records 1-25


rsName2

"SELECT * FROM names ORDER BY last_name ASC limit 25, 25 "

displays records 25-50


rsName3

"SELECT * FROM names ORDER BY last_name ASC limit 50, 25 "

displays records 50-75

etc.