records in table

[sniffer]

Hi

I have an Access db and I want to display the records in the database in a table. I want to display 5 records on each row, so first it loop through the database and pick the 5 first records and then it creates a new row and pick the next 5 records etc.. So when it have picked out, say 15 records I want it to create a new page and the show the rest of the records on the second page, a paging system.

I have tested differents methods but without any results.

I would be grateful if someone can help me with this. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[ivory]

you need to create an incremental loop that counts up as you step through your recordset - and use an if...then statement to draw your cell/row opening and closing tags every 5 records.

something like
<table>
<%
i = 0 'your incremental loop - define it outside your recordset loop
while not recordset.eof 'start your recordset loop
if i = 0 or i mod 5 = 0 then
'insert your html to open the row/first cell
else
'insert your html to open the 2nd, 3rd, 4th, or 5th cell
end if
'display your recordset content
i = i + 1 'step up your incremental loop by 1.
if i = 0 or i mod 5 = 0 then
'insert your html to close the row/last cell
else
'insert your html to close the 1st, 2nd, 3rd, or 4th cell
end if
recordset.movenext 'proceed to the next record in the recordset.
wend
%>
</table>

and then create a link to the n -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --