DaniWeb Forum Index > Web Development > ASP

horizontal loop from database records

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2005

Posts: 131

Reputation: william_stam is an unknown quantity at this point

Solved Threads: 2

william_stam william_stam is offline

Offline

Junior Poster

horizontal loop from database records

Apr 7th, 2005

Hi

I have a site that lists a companies products (lots). It has a database table containing these records. I want to loop the records to show 2 accross and the rest down (2 records per row by unlimited rows). it is possible because i made a mistake on an ordinary loop and it did this but i lost my mistake and can't remember what i did.

Help is appreciated ( :eek: I got a deadline :cry: )

•

Join Date: Apr 2004

Posts: 167

Reputation: Drew is an unknown quantity at this point

Solved Threads: 7

Drew

Offline

Junior Poster

Re: horizontal loop from database records

Apr 9th, 2005

So are you trying to loop through the records so its 2 records a single row? I really dont understand what you are trying to do... :s

Drew Gauderman
ASP / MSSQL Coder
http://www.iportalx.net - My ASP Portal

•

Join Date: Mar 2005

Posts: 131

Reputation: william_stam is an unknown quantity at this point

Solved Threads: 2

william_stam william_stam is offline

Offline

Junior Poster

Re: horizontal loop from database records

Apr 11th, 2005

basicaly what i want is:
1 2
3 4
5 6
7 8 etc

•

Join Date: Mar 2005

Posts: 131

Reputation: william_stam is an unknown quantity at this point

Solved Threads: 2

william_stam william_stam is offline

Offline

Junior Poster

Re: horizontal loop from database records

Apr 12th, 2005

Ok so at about 12 (very late) I came up with a solution

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<table width="300" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <% Dim nextline, todisplay, endof
todisplay = 2
nextline = 0 
endof = 0
%>
    <% do while endof <> (Recordset1_total) AND (NOT Recordset1.EOF)%>
    <% endof = endof + 1 %>
    <% If nextline = todisplay Then %>
    <% nextline = 0 %>
  </tr>
  <tr>
    <% End If %>
    <% nextline = nextline + 1 %>
    <td><%=(Recordset1.Fields.Item("ID").Value)%></td>
    <%  Recordset1.MoveNext() %>
    <% loop %>
  </tr>
</table>
<table width="300" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <% Dim nextline, todisplay, endof
todisplay = 2
nextline = 0 
endof = 0
%>
    <% do while endof <> (Recordset1_total) AND (NOT Recordset1.EOF)%>
    <% endof = endof + 1 %>
    <% If nextline = todisplay Then %>
    <% nextline = 0 %>
  </tr>
  <tr>
    <% End If %>
    <% nextline = nextline + 1 %>
    <td><%=(Recordset1.Fields.Item("ID").Value)%></td>
    <%  Recordset1.MoveNext() %>
    <% loop %>
  </tr>
</table>

The "Recordset1_total" is the amount of total records in the recordset