asp 表格 图片 循环

来源:百度知道 编辑:UC知道 时间:2024/06/14 14:13:18
我要实现一个效果,在网页下部显示一行图片,从数据库读取的,图片循环滚动,代码如下

<%
sql="select top 11 * from NEWS where firstImageName<>'' and ok=true order by ID DESC"
set rs=conn.execute(sql)
if not Rs.eof then
do while not rs.eof
%>
<%if not rs.eof then%>

循环部分

<table width="121" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><div align="center" ><a href="onews.asp?id=<%=rs("id")%>" target="_blank" ><img

src="uppic/<%=trim(rs("firstImageName"))%>" width="100"

height="90" border="0"></a></div></td>
</tr>
<tr>
<td height="25" align="center"><a href="onews.asp?id=<%

<HTML><HEAD><TITLE>无标题文档</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META content="MSHTML 6.00.2800.1264" name=GENERATOR>
<link href="css.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY leftMargin=0 topMargin=2 marginheight="0" marginwidth="0">
<CENTER>
<TABLE
style="BORDER-RIGHT: #666666 1px solid; BORDER-TOP: #666666 1px solid; BORDER-LEFT: #666666 1px solid; BORDER-BOTTOM: #666666 1px solid"
cellSpacing=0 cellPadding=0 width=750 align=center border=0>
<TBODY>
<TR>
<TD>
<DIV id=demo style="OVERFLOW: hidden; WIDTH: 100%; COLOR: #ffffff">
<TABLE cellSpacing=0 cellPadding=0 align=left border=0 cellspace="0">
<TBODY>
<TR>