SQL HELP - SELECT STATEMENT

I need to select the TOP 16 rows and for each row, create a field so I can manually place it on a page (in a confined layout) without having to do all kinds of jibberish repeat region statements and what not.

Is this possible? If so, what is the statement to do it?

The page I am trying to do this on is @ www.rotsquad.com/tournament/brackets.asp - you'll see I need to display certain records based on some filters but with that layout you cannot do repeat regions or even nested.

SELECT TOP 16 * FROM FIELD

That will only pull the top 16 records out of a select field right? Well, I need each of those records pulled to be created as a FIELD ITEM. 

Like when you do:

SELECT COUNT(tournid) AS totaltournid or something.

Basically, I need to collect the content of recordset into an array so I can individually place values from the recordset.

How do I do all that?

I think I have it working for now ... I was trying to use a basic array and kept getting a Type Mismatch.

Thanks for steering me in the right direction!

<-- newb