When it comes to displaying records from a database on a web page, using a table to organize your data has long been one of the most commonly used methods. Many websites use tables to display their records vertically. However, you may also need to occasionally display your records horizontally.
To do this, create a database called MyDatabase and a table called tblData with these fields:
ID – autonumber
Item – text field
Next, create a page called /DisplayHoriz.asp and copy the below code into your page:
<!--#INCLUDE VIRTUAL="/includes/connection.asp" -->
<%
DIM mySQL, objRS
mySQL = "SELECT * FROM tblData"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open mySQL, objConn
DIM recCount
IF Not objRS.EOF THEN
Response.Write "<table width='100%'>"
recCount = 0
Do UNTIL objRS.EOF
IF recCount Mod 3 = 0 THEN
IF recCount <> 0 THEN
Response.Write "</tr>"
Response.Write "<tr><td>"&objRS("Item")&"</td>"
ELSE
Response.Write "<td>"&objRS("Item")&"</td>"
END IF
recCount = recCount + 1
objRS.MoveNext
Loop
Response.Write"</tr></table>"
ELSE
Response.Write "Sorry, there are no records in our database."
END IF
%>
This script will return all of your records and display them in a table on your page. It will display three records horizontally in a table row, end the current row, start a new row, and display three more records. If you want to display more records horizontally, simply change the “3” in this line: IF recCount Mod 3 = 0 THEN to however many records you want to display in each row.