zhuan.asp

来自「asp的网上卖东西的..看看还可以的吧」· ASP 代码 · 共 27 行

<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
        <%
		set rs=server.createobject("adodb.recordset")
		rs.open "select Top 6 * FROM BJX_zhuanti order by newsid desc",conn,1,1
		if rs.recordcount=0 then 
		else%>
<tr> 
<td height="30" bgcolor="#efefef">↓↓商品专题</td>
</tr>
          <%
			while not rs.eof
			%>
          <tr> 
            <td height=24 width="10%" class="table-xia">&nbsp;☉
            <a href=listzt.asp?id=<%=rs("newsid")%> ><%=replace(trim(rs("title")),"<br>","")%></a>
            <%=year(rs("updatetime"))&"."&month(rs("updatetime"))&"."&day(rs("updatetime"))%></td>
          </tr>
          <%
			rs.movenext
		    wend
			%>
        </table>
        <%
		end if
		rs.close
		set rs=nothing
		%>