Loop laver dem under hinanden med ønsker at de paceres ved siden af.
J skal kun hente de sidste to poster i db og ønsker at de bliver placeret ved iden af hinanden i steden for nu under hindanden.//cdc
koden er her:
<%
dim rs
dim rs2
dim cn
dim msg
set cn = Server.CreateObject("Adodb.Connection")
set rs = server.CreateObject("Adodb.Recordset")
cn.Open conn
sqlstring = "Select * From ProductCategories"
rs.open sqlstring, cn
%>
<tr>
<td width="23"></td>
<td width="500" style="padding-right: 10px">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" valign="top"><div align="left">
<font color="#FF0000">
<%if not request.QueryString("cid")<>"" then%>
</font>
<%end if%>
<%
if request.QueryString("cid")<>"" then
set rs = cn.execute("Select * From Products Where CategoryID=" & request.QueryString("cid"))
end if
%>
<%
if not rs.eof then
while not rs.eof
%>
<table width="180" border="0" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#6B6B63">
<table border="0" width="100%" cellspacing="0" cellpadding="4">
<tr>
<td width="100%" class="topText"><font color="#FFFFFF"><%=rs.fields("productname")%></font></td>
</tr>
</table>
</td>
</tr>
<%if rs.fields("image")<>"" then%>
<tr>
<td><img border="0" src="../image/spacer.gif" width="2" height="4"></td>
</tr>
<tr>
<td height="20"><a href="ProductCatalog/aspProductCatalog/images/products/<%=rs.fields("image")%>" rel="lightbox"><img name="image" src="ProductCatalog/aspProductCatalog/images/products/<%=rs.fields("image")%>" width="230" height="230" alt="" style="border-width: 1px; border-style: solid ; border-color: black;"></a></td>
</tr>
<tr>
<%end if%>
<td height="20"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><%=rs.fields("details")%></font></font></div></td>
</tr>
<tr>
<td align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Pris:
<font color="#FF0000"><%=rs.fields("price")%>,00 kr.</strong></font></strong></font></td>
</tr>
</table>
<%
rs.movenext
wend
else
'response.Write("No products")
end if
%>
</div>
</td>
</tr>
</table>
