
网页代码问题
<tablewidth="100%"border="0"cellpadding="0"cellspacing="0"bgcolor="#FFFFFF"><%sqlf="s...
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<%sqlf="select * from web_pic order by id desc"
set rsf=conn.execute(sqlf)
%>
<tr>
<td bgcolor="#FFFFFF">
<marquee behavior="scroll" direction="left" onmouseover="stop()" onmouseout="start()" width="890"
scrollamount="2" align="middle">
<table border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<%
i=1
do while rsf.eof=false%>
<td valign="top">
<table width="106" border="0" cellspacing="0" cellpadding="2">
<tr>
<td valign="top">
<a href="news_xian2.asp?id=<%=rsf(0)%>"> </a><a href="news_xian2.asp?id=<%=rsf(0)%>"><img src="<%=rsf(3)%>" alt="" width="110" height="100" border="0" /></a></td>
</tr>
<tr>
<td width="102" height="25" valign="top" align="center"><%=rsf(1)%></td>
</tr>
</table>
<div align="center"></div></td>
<%
i=i+1
rsf.movenext
loop
%>
</tr>
</table></marquee>
</td>
</tr>
</table>
这样的代码,后台添加图片的,是显示所有的添加图片,我现在想显示最近添加的10张图片,应该怎么弄!
谢谢大家! 展开
<%sqlf="select * from web_pic order by id desc"
set rsf=conn.execute(sqlf)
%>
<tr>
<td bgcolor="#FFFFFF">
<marquee behavior="scroll" direction="left" onmouseover="stop()" onmouseout="start()" width="890"
scrollamount="2" align="middle">
<table border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<%
i=1
do while rsf.eof=false%>
<td valign="top">
<table width="106" border="0" cellspacing="0" cellpadding="2">
<tr>
<td valign="top">
<a href="news_xian2.asp?id=<%=rsf(0)%>"> </a><a href="news_xian2.asp?id=<%=rsf(0)%>"><img src="<%=rsf(3)%>" alt="" width="110" height="100" border="0" /></a></td>
</tr>
<tr>
<td width="102" height="25" valign="top" align="center"><%=rsf(1)%></td>
</tr>
</table>
<div align="center"></div></td>
<%
i=i+1
rsf.movenext
loop
%>
</tr>
</table></marquee>
</td>
</tr>
</table>
这样的代码,后台添加图片的,是显示所有的添加图片,我现在想显示最近添加的10张图片,应该怎么弄!
谢谢大家! 展开
3个回答
展开全部
</HEAD>
<BODY bgColor=#e2f8f9 leftMargin=0 topMargin=0 marginheight="0" marginwidth="0">
<CENTER>
<table border="0" width="900" cellspacing="5" cellpadding="0">
<tr>
<td width="20"><img id="r_l" onClick="r_left()"src="/Skin/webui_07AT/moveleft.gif
">
</td>
<td>
<TABLE cellSpacing=0 cellPadding=0 width=900 border=0>
<TBODY>
<TR>
<TD vAlign=top background="" height=120>
<TABLE cellSpacing=0 cellPadding=0 width=900 border=0>
<TBODY>
<TR>
<TD vAlign=center align=middle height=120>
<!--------------------demo start------------------>
<DIV id=demo style="OVERFLOW: hidden; WIDTH: 900px; COLOR: #e2f8f9; HEIGHT: 120px">
<TABLE cellPadding=0 width="100%" align=left border=0
cellspace="0">
<TBODY>
<TR>
<!--------------------demo1--------------------->
<TD id=demo1 vAlign=top>
<TABLE cellSpacing=1 cellPadding=1>
<TBODY>
<TR vAlign=top>
<TD vAlign=top noWrap>
<DIV align=right>
<TABLE cellSpacing=0 cellPadding=0 align=center border=0>
<TBODY>
<TR>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="/Photo/UploadPhotos/200711/20071116231323510.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>借母溪风光1</A></TD></TR></TBODY></TABLE></TD>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="E:\新建文件夹\u=464684302,3262278364&fm=0&gp=6.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>借母溪风光2</A></TD></TR></TBODY></TABLE></TD>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="/Photo/UploadPhotos/200711/20071116231233199.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>借母溪风光3</A></TD></TR></TBODY></TABLE></TD>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="/Photo/UploadPhotos/200711/20071116231204316.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>借母溪风光4</A></TD></TR></TBODY></TABLE></TD>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="/Photo/UploadPhotos/200711/20071117083727614.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>校园艺术节剪影1</A></TD></TR></TBODY></TABLE></TD>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="/Photo/UploadPhotos/200711/20071117083904511.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>校园艺术节剪影2</A></TD></TR></TBODY></TABLE></TD>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="/Photo/UploadPhotos/200711/20071117083954859.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>校园艺术节剪影3</A></TD></TR></TBODY></TABLE></TD>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="/Photo/UploadPhotos/200711/20071117084022871.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>校园艺术节剪影4</A></TD></TR></TBODY></TABLE></TD>
</TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE></TD>
<!-------------------demo2--------------------->
<TD id=demo2 width="0"></TD>
</TR></TBODY></TABLE></DIV>
<!--------------------demo end------------------>
<SCRIPT>
var dir=1//每步移动像素,大=快
var speed=1//循环周期(毫秒)大=慢
demo2.innerHTML=demo1.innerHTML
function Marquee(){//正常移动
//alert(demo2.offsetWidth+"\n"+demo.scrollLeft)
if (dir>0 && (demo2.offsetWidth-demo.scrollLeft)<=0) demo.scrollLeft=0
if (dir<0 &&(demo.scrollLeft<=0)) demo.scrollLeft=demo2.offsetWidth
demo.scrollLeft+=dir
demo.onmouseover=function() {clearInterval(MyMar)}//暂停移动
demo.onmouseout=function() {MyMar=setInterval(Marquee,speed)}//继续移动
}
function r_left(){if (dir=-1)dir=1}//换向左移
function r_right(){if (dir=1)dir=-1}//换向右移
var MyMar=setInterval(Marquee,speed)
</SCRIPT>
</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
</td>
<td width="20"><img id="r_r" onClick="r_right()" src="/Skin/webui_07AT/moveright.gif">
<BODY bgColor=#e2f8f9 leftMargin=0 topMargin=0 marginheight="0" marginwidth="0">
<CENTER>
<table border="0" width="900" cellspacing="5" cellpadding="0">
<tr>
<td width="20"><img id="r_l" onClick="r_left()"src="/Skin/webui_07AT/moveleft.gif
">
</td>
<td>
<TABLE cellSpacing=0 cellPadding=0 width=900 border=0>
<TBODY>
<TR>
<TD vAlign=top background="" height=120>
<TABLE cellSpacing=0 cellPadding=0 width=900 border=0>
<TBODY>
<TR>
<TD vAlign=center align=middle height=120>
<!--------------------demo start------------------>
<DIV id=demo style="OVERFLOW: hidden; WIDTH: 900px; COLOR: #e2f8f9; HEIGHT: 120px">
<TABLE cellPadding=0 width="100%" align=left border=0
cellspace="0">
<TBODY>
<TR>
<!--------------------demo1--------------------->
<TD id=demo1 vAlign=top>
<TABLE cellSpacing=1 cellPadding=1>
<TBODY>
<TR vAlign=top>
<TD vAlign=top noWrap>
<DIV align=right>
<TABLE cellSpacing=0 cellPadding=0 align=center border=0>
<TBODY>
<TR>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="/Photo/UploadPhotos/200711/20071116231323510.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>借母溪风光1</A></TD></TR></TBODY></TABLE></TD>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="E:\新建文件夹\u=464684302,3262278364&fm=0&gp=6.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>借母溪风光2</A></TD></TR></TBODY></TABLE></TD>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="/Photo/UploadPhotos/200711/20071116231233199.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>借母溪风光3</A></TD></TR></TBODY></TABLE></TD>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="/Photo/UploadPhotos/200711/20071116231204316.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>借母溪风光4</A></TD></TR></TBODY></TABLE></TD>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="/Photo/UploadPhotos/200711/20071117083727614.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>校园艺术节剪影1</A></TD></TR></TBODY></TABLE></TD>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="/Photo/UploadPhotos/200711/20071117083904511.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>校园艺术节剪影2</A></TD></TR></TBODY></TABLE></TD>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="/Photo/UploadPhotos/200711/20071117083954859.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>校园艺术节剪影3</A></TD></TR></TBODY></TABLE></TD>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width=150
align=center border=0>
<TBODY>
<TR>
<TD align=middle height=100><A
href="#"
target=_blank><IMG height=98
src="/Photo/UploadPhotos/200711/20071117084022871.jpg" width=130
border=0></A></TD></TR>
<TR>
<TD class=nav1 align=middle height=20><A
class=apm2
href="#"
target=_blank>校园艺术节剪影4</A></TD></TR></TBODY></TABLE></TD>
</TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE></TD>
<!-------------------demo2--------------------->
<TD id=demo2 width="0"></TD>
</TR></TBODY></TABLE></DIV>
<!--------------------demo end------------------>
<SCRIPT>
var dir=1//每步移动像素,大=快
var speed=1//循环周期(毫秒)大=慢
demo2.innerHTML=demo1.innerHTML
function Marquee(){//正常移动
//alert(demo2.offsetWidth+"\n"+demo.scrollLeft)
if (dir>0 && (demo2.offsetWidth-demo.scrollLeft)<=0) demo.scrollLeft=0
if (dir<0 &&(demo.scrollLeft<=0)) demo.scrollLeft=demo2.offsetWidth
demo.scrollLeft+=dir
demo.onmouseover=function() {clearInterval(MyMar)}//暂停移动
demo.onmouseout=function() {MyMar=setInterval(Marquee,speed)}//继续移动
}
function r_left(){if (dir=-1)dir=1}//换向左移
function r_right(){if (dir=1)dir=-1}//换向右移
var MyMar=setInterval(Marquee,speed)
</SCRIPT>
</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
</td>
<td width="20"><img id="r_r" onClick="r_right()" src="/Skin/webui_07AT/moveright.gif">
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
把上面的
<%sqlf="select * from web_pic order by id desc"
set rsf=conn.execute(sqlf)
%>
改成
<%sqlf="select top 10 * from web_pic order by id desc"
set rsf=conn.execute(sqlf)
%>
<%sqlf="select * from web_pic order by id desc"
set rsf=conn.execute(sqlf)
%>
改成
<%sqlf="select top 10 * from web_pic order by id desc"
set rsf=conn.execute(sqlf)
%>
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
2008-05-23
展开全部
<%sqlf="select top 10 * from web_pic order by id desc"
set rsf=conn.execute(sqlf)
%>
set rsf=conn.execute(sqlf)
%>
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询