Hi there

I'm wanting to display the output of a select statement on a web page. However, my problem arises because I don't want to display them as a list; I want to loop through them displaying 2 records horizontally next to each other on the page (i.e in a table) and then the next 2 in a table underneath and so it goes on.

Can anyone help me here?

thanks alot

Adam

Just keep a count as you're going through the records and write a new <tr> when theCount Mod 2 = 0

thanks Phil

Do you have an example I might be able to follow?

I've tried using it like so:

 <%counter = 0%>
  <%do while not rsWeekdays.EOF%>
    <%counter = counter + 1
        if counter mod (7 + 1) = 0 then%>
        </tr>
        <tr>
       <%end if%>
            <td>
            <div align="center">&nbsp;&nbsp;|&nbsp;&nbsp;<a href="mypage.asp?TipID=<%=rsWeekdays("TipID")%>">& nbsp;&nbsp;<%=rsWeekdays("Weekday")%></a>
         <%rsWeekdays.movenext%>
               <%loop%>
</div></td>
          </tr>
        </table>

but that just seems to go horizontal across the page which is halfway to what I want but not the full way

Many thanks

Adam

Adam, this line

if counter mod (7 + 1) = 0 then

will give you a new row every 8 records, so change it to

if counter mod 2 = 0 then

rgds
Phil

ok, thanks alot:)