productlist11.asp

以前企业建网站

<%
sql="select top 6 * from hw where hw_jp=true order by hw_id desc "
rs.open sql,conn,3,3
if rs.eof then
%>
暂且没有商品                                                                                                                                               
<%end if %>                       
<table width="439" 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="128">
<table width="104%" border="0" cellspacing="0" cellpadding="0">                 
<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">商城价：</font><b><font color="#FF0000">￥<%=rs("hw_cash1")%></font></b><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="126">                 
<table width="100%" border="0" cellspacing="0" cellpadding="0">                 
<tr>                 
<td height="71"><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>                 
</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>