数据提取问题

<%
      sql="select * from pic4 where piccat_id=29 order by pic_id asc"
    set rs=server.createobject("adodb.recordset")
    rs.open sql,conn,1,1
     %>
            <table width="210" border="0" cellspacing="0" cellpadding="0" align="center">
              <tr>
                <td colspan="2" height="5"></td>
              </tr>
              <tr>
                <td width="96"><div align="center"><img src="<%=rs("pic_spic")%>" width="90" height="80" border="0"></div></td>
                <td width="120"><table width="100%" border="0" cellspacing="0" cellpadding="1">
                  <tr>
                    <td>本期：<%=rs("pic_name")%></td>
                  </tr>
                  <tr>
                    <td><%=rs("ssgs")%></td>
                  </tr>
                  <tr>
                    <td height="5"></td>
                  </tr>
                  <tr>
                    <td height="1" bgcolor="aaaaaa"></td>
                  </tr>
                  <tr>
                    <td height="5"></td>
                  </tr>
<tr>
 <td>下期：<%
 rs.moveprevious
 rs.movenext
 rs.movenext
  if rs.eof then
 response.write "暂无消息"
 else
%> <%=rs("pic_name")%></td>
<% end if %>
                  </tr>
                  <tr>
                    <td><%=rs("ssgs")%></td>
                  </tr>
                </table>

如图的显示 已经实现了我想要的基本功能 但是我从后台传新的资料上去后 并没有发生变化 估计是中间的ID值断了的原因 请问如何修改才能实现同步更新?

[[italic] 本帖最后由 sydpoechang 于 2007-12-24 13:36 编辑 [/italic]]