28,406
社区成员
发帖
与我相关
我的任务
分享 <!-- end #sidebar2 --></div>
<div id="mainContent">
<ul style="list-style-type:none;">
<li class="centerbk_t"></li>
<li class="centerbk_c">
<%
dim rs,sql
set rs= server.CreateObject("adodb.recordset")
sql="select top 4 * from products where p_bcid=1 order by p_id"
rs.open sql,conn,1,1
if not (rs.bof or rs.eof) then
do while not rs.eof
%>
<ul>
<li style="display:inline;"><img src="images/tp-7.jpg" hspace="5" vspace="5" /> <img src="<%=rs("p_img")%>" width="100" height="89" vspace="5" /> <img src="images/tp-7.jpg" vspace="5" /></li>
</ul>
<ul style="height:30px;">
<li style="display:inline; padding:3px;"> <img src="images/tp-24.jpg" /><%=rs("p_name")%></li>
</ul>
<ul style="height:30px;">
<li style="display:inline; padding:5px;"><img src="images/tp-25.jpg" /> ¥<%=rs("price1")%></li>
</ul>
</li>
<li class="centerbk_b"></li>
</ul>
<%
rs.movenext
loop
end if
rs.close
set rs= nothing
%>
</li>
<li class="centerbk_b"></li>
</ul>