[zanchi]

Hi, I want to display 3 items per row. The following code displays only one item per row. Then if it is possible i need to have 15 items per page, that is 5 rows, the it will be another page (Next page) to display more items.

Thank very much

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("markcamilleri.mdb"))
 
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT ProductID, TemplateNumber, Description, Image1, Preview FROM templates WHERE CategoryID=1", conn
'If no record found, end.
   if rs.eof then
    response.Write("No Records")
    'rs.Close
    'Response.End
   end if
%>
          </p>
            <table border="0" cellpadding="10" cellspacing="10">
              <% 
Do While Not rs.EOF 
%>
              <tr>
                <td width="151"><img src="<%= rs.Fields("Image1").Value %>" width="215" height="199"></td>
                <td width="152"><%= rs.Fields("Description").Value %></td>
                <td width="233"><%= rs.Fields("TemplateNumber").Value %></td>
                <td width="233"><a href="<%= rs.Fields("Preview").Value %>" target="_blank">Preview</a>
                </td>
              </tr>
              <% 
rs.MoveNext 
Loop 
%>
    </table>
    <% 
' Close our recordset and connection and dispose of the objects 
rs.Close 
set rs = Nothing 
conn.Close 
set conn = Nothing 
 
%> 

i dont have a sample or the time to write one now before class but what you need to do is create a counter that runs and do modulous (intcounter mod 3) and if that is 0 then insert </tr><tr> tags else continue. then to finish it out you will want another loop to fill in the blank spaces up to three if eof occurs before the end of a row

i'll be glad to help if you want to take another shot at it before i get some sample code dug up or written

[v3rt1go]

To avoid using another loop to fill in data you could do something like this:

<% index = 0 -%>
<% @products.each do |prod| -%>
<% if index%3 == 0 -%>
<tr>
<% end -%>
<td class="product">
product data goes here
</td>
<% if index%3 == 2 -%>
</tr>
<% end -%>
<% index +=1 -%>
<% end -%>

This way you'll open the tr tag if the result of the mod calculation is 0 and close the tr tag if the result is 2 (last element in the row). If you want to change the number of tds shown in a row just change the mod calculation like this: index%x = 0 for opening the tr tag and index%x = x-1 for closing the tr tag, where x is the number of tds you want to display. Don't forget to add 1 to the index at the end of the loop.

Edit: MY BAD the above code is Ruby, but it's the same for ASP. Just noticed what i was browsing )