Click to See Complete Forum and Search --> : displaying of retrieved data


tasneem
08-23-2005, 06:44 PM
Hi
How do I display items retrieved from database in a column-based list? All I can get is a list, which goes on and on (I have done the paging part). For one page, I want the list to be displayed in columnar form. Something like featured brands link seen on http://www.buyonlinenow.com/
Thanks.

gerjanschoemake
08-24-2005, 05:05 AM
I don't know if it's the best way, but you can do something like this:

<table width="95%" border="0" align="center" cellpadding="10" cellspacing="0">
<tr valign="top">
<td width="50%">
<%
For intI = 1 to 150
%>
<%=name1%><br>
<%=address1%><br>
<%=country1%><br>
<%=image1%><br>
<%
objRS.MoveNext
If objRS.EOF Then Exit For
Next
%>
</td>
<td width="50%"><%
For intI = 1 to 150
%>
<%=name1%><br>
<%=address1%><br>
<%=country1%><br>
<%=image1%><br>
<%
objRS.MoveNext
If objRS.EOF Then Exit For
Next
%>
</td>
</tr>
</table>


Here you have two columns, but ofcourse you can add as many as you like! :)

tasneem
08-24-2005, 01:44 PM
Hi
thanks, that did work, you can see the result at http://site272.webhost4life.com/dzigner/
thanks

gerjanschoemake
08-25-2005, 06:12 AM
No problem :)