Ad:

ASP Discussion Thread
Unsolved
Views: 7198

Apr 7th, 2005

horizontal loop from database records

Expand Post »

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: )

Similar Threads

access database search and display in Visual Basic 4 / 5 / 6
FlexGrid issue and error "Invalid Row value".... in Visual Basic 4 / 5 / 6
how to insert data from dataset into database in VB.NET
Access Database file conversion in Database Design
fsockopen Jumping out of Loop in PHP

william_stam

Reputation Points: 10

Solved Threads: 2

Junior Poster

Offline

131 posts
since Mar 2005

Permalink

Apr 9th, 2005

Re: horizontal loop from database records

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

Reputation Points: 25

Solved Threads: 7

Junior Poster

Offline

166 posts
since Apr 2004

Permalink

Apr 11th, 2005

Re: horizontal loop from database records

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

william_stam

Reputation Points: 10

Solved Threads: 2

Junior Poster

Offline

131 posts
since Mar 2005

Permalink

Apr 12th, 2005

Re: horizontal loop from database records

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

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

william_stam

Reputation Points: 10

Solved Threads: 2

Junior Poster

Offline

131 posts
since Mar 2005

Permalink

Nov 24th, 2009

thank you

thank you for this reference

sutil

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Nov 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: IIS URL decoding

Next Thread in ASP Forum Timeline: Active Directory- extracting groups

DaniWeb Message

Cancel Changes

User Name
Password