productlist.asp

以前企业建网站

<%                
sql="select top 6 * from hw where hw_xp=true order by  hw_id  DESC"
rs.open sql,conn,3,3                
if rs.eof then                
%>
暂且没有商品<%end if %>                       
<table width="437" border="0" cellspacing="0" cellpadding="3">                 
<%
i=0
do while not rs.eof and i<=3 %> 
<tr>                 
<td width="80" valign="top">                 
<div align="center">                 
<a href="watch.asp?hw_id=<%=rs("hw_id")%>"><img border="1" src="picture/<%=rs("hw_pic")%>" width="78" height="102" class="border"></a>                 
</div>                 
</td>                 
<td valign="top" width="127">                 
<table width="104%" border="0" cellspacing="0" cellpadding="0" height="93">                 
<tr>                 
<td><a href="watch.asp?hw_id=<%=rs("hw_id")%>"><font color="#FF0000">
<p style="line-height: 150%"><%=rs("hw_name")%></font></a><br>                 
市场价：<s>￥<%=rs("hw_cash")%></s><br>
<font color="#FF0000">商城价：<b>￥<%=rs("hw_cash1")%></b></font><br>                 
商品编号：                         
<%=rs("hw_id")%>  
</td>                  
</tr>                  
<tr>                  
<td>                  
<div align="center">                 
<a href="javascript:openbag(<%=rs("hw_id")%>)"><img border="0" src="images/p2.jpg" width="93" height="26"></a></div>                 
</td>                 
</tr>                 
</table>                 
</td>                 
<% rs.movenext %>  
<%if not rs.eof then%>             
<td width="81" valign="top">                 
<div align="center">                 
<a href="watch.asp?hw_id=<%=rs("hw_id")%>"><img border="1" src="picture/<%=rs("hw_pic")%>" width="78" height="102" class="border"></a>                 
</div>                 
</td>                 
<td valign="top" width="125">                 
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="91">                 
<tr>                 
<td><a href="watch.asp?hw_id=<%=rs("hw_id")%>"><font color="#FF0000">
<p style="line-height: 150%"><%=rs("hw_name")%></font></a><br>                 
市场价：<s>￥<%=rs("hw_cash")%></s><br>
<font color="#FF0000">商城价：<b>￥<%=rs("hw_cash1")%></b></font><br>                
商品编号：                         
<%=rs("hw_id")%>             
</td>                  
</tr>                  
<tr>                  
<td height="26">                  
<div align="center">                 
<a href="javascript:openbag(<%=rs("hw_id")%>)"><img border="0" src="images/p2.jpg" width="93" height="26"></a>                 
</div>                 
</td>                 
</tr>                 
</table>                 
</td>                 
</tr>                 
<%
i=i+1
rs.movenext                 
else
%> 
<td width="81" valign="top"> </td>
<td width="125" valign="top"> </td>
<%
end if
loop %>       
                
<%rs.close
%>

</table>