hello,
I am trying to develop a shopping site in ASP. For this I need to fetch product info from database abd arrange them in rows and columns.
I want products to be arranged in 3 col & 2 rows...i.e total 6 product on 1 page .

plz guide me as to how to arrange records 1> page wise i.e six records per page 2> arrange records in rows & columns.

u can see wat I am trying to achieve at http://www.romanapole.com/top.asp

I will be greatly obliged to all those who reply.

I am a final year student and trying to do this for my project. plz help.

regards

moushumi

This question ever get addressed?

I think this'll work okay.

set rs = server.createobject("adodb.recordset")
sql = "SELECT * FROM table"
rs.Open sql, cn '<--your connection object--
if not rs.eof then
    response.write "<table><tr>"
    do while not rs.eof
    count = count + 1
    response.write "<td>" & oRS("Score") & "%</td>"
    if count = 3 then
        response.write "</tr><tr>"
        count = 0
    end if
    oRS.movenext
    loop
    response.write "</tr></table>"
end if
oRS.close
set oRS = nothing