以下代码为何从第二部开始显示，不显示第一部？

[cdwfeng]

<%
set rs=server.createobject("adodb.recordset")
sql="SELECT * FROM 影片 where 显示='是' and 分类= '10' order by id desc"
rs.Open sql,conn,1,1
%>
<table cellspacing=0 cellpadding=0 width=764 align=center border=0>
<tbody>
<tr>
<td width="764" height=5 bgcolor=#0099ff>
<div align=center></div>
</td>
</tr>
<tr>
<td><img height=48 src="images/tvplay.gif"
width=760></td>
</tr>
<tr>
<td valign=top background=images/00_bestmovie_bg.gif
height=215>
<table cellspacing=0 cellpadding=0 width="100%"
border=0>
<tbody>
<tr>
<td valign=top width="20%">
<table width="94%" border="0" cellspacing="5">
<tr>
<td>
<table cellspacing=0 cellpadding=1 width=137 align=center
border=0>
<tbody>
<tr>
<td width=135 ><table cellspacing=0 cellpadding=3 width="99%"
border=0>
<tbody>
<tr>
<td width="23%" height="167" bgcolor=#ffffff><table cellspacing=0 cellpadding=0 align=center
border=0>
<tbody>
<tr>
<td ><table cellspacing=1 cellpadding=3 border=0>
<tbody>
<tr>
<td width="30" valign=top bgcolor=#ffffff>
</tbody>
</table>
</td>
</tr>
</table>
</td>
<td width="80%" valign=top>
<table width="100%" border="0" cellspacing="5">
<tr>
<%
for i=1 to 2
if not rs.eof then rs.movenext
%>
<td height="201">
<table cellspacing=0 cellpadding=1 width=105 align=left
border=0>
<tbody>
<tr>
<td width=103 >
<table width="245" border="0" cellspacing="0" cellpadding="5" align="center">
<tr>
<td width="112" height="170">
<table cellpadding=3
align=center border=0 cellspacing=1>
<tbody>
<tr>
<td width="106" height="170" >
<table height=156 cellspacing=0 cellpadding=0
width=104 align=center border=0>
<tbody>
<tr>
<td height="119">

<div align="center">
<%if site_runscript="asp" then
Rw "<a href=film_view.asp?id="&rs("id")&"><img src='../"&film_pic&"/"&rs("小图")&"' width=110 height=139 border=0 title="&rs("影片名")&"></a>"
else
Rw "<a href=film_view_"&md5(rs("id"),32)&".html><img src='../"&film_pic&"/"&rs("小图")&"' width=140 height=168 border=0 title="&rs("影片名")&"></a>"
end if%>
</div></td>
</tr>
<tr>
<td height="15"><div align="center"><img src="../images/<%=rs("格式")%>.gif" align=absmiddle>
<%if site_runscript="asp" then
Rw "<a href=film_view.asp?id="&rs("id")&" title="&rs("影片名")&">"&rs("影片名")&"</a>"
else
Rw "<a href=film_view_"&md5(rs("id"),32)&".html title="&rs("影片名")&">"&rs("影片名")&"</a>"
end if%>
</div></td>
</tr>
</tbody>
</table> </td>
</tr>
</tbody>
</table> </td>
<td width="111"><table width="105" height="164" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="105"><img src="images/xbg.gif"> 主演：<%=rs("主演")%></td>
</tr>
<tr>
<td><img src="images/xbg.gif"> 产地：<%=rs("出产地")%></td>
</tr>
<tr>
<td><img src="images/xbg.gif"> 人气：<%=rs("人气")%></td>
</tr>
<tr>
<td><img src="images/xbg.gif"> 片长：<%=rs("集数")%>集</td>
</tr>

<tr>
<td><img src="images/xbg.gif"> 时间：<%=datevalue(rs("加入时间"))%></td>
</tr>
</table> </td>
</tr>
</table>
</td>
</tr>
</tbody>
</table>
</td>
<%
if i mod 2 = 2 then Rw "</tr><tr>"
next
%>
</tr>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>

[zjsfdxbao]

原因在于

  <% 
  for i=1 to 2 
  if not rs.eof then rs.movenext 
  %> 

这一个代码节里面的rs.movenext
你在内容还没开始前就把记录集的指针往下移动了,所以记录是从第2行开始显示(因为获取到记录集后指针默认在第一行)
应该把rs.movenext 挪到next之前就可以了