我数据库里有11条记录,可他显示的实际只有6条,为什么?
<table width="627" height="22" border="1">
<%
DB="mysql.mdb"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DB)
objconn.open
strSQL = "SELECT * FROM admin"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSQL, objConn, 1, 3
i=objrs.recordcount '统计objrs中的数据个数
for k=1 to i %>
<tr>
<td width="154"><%=objrs("name")%></td>
<td width="106"><%=objrs("password")%></td>
<td width="238"><%=objrs("class")%></td>
<td width="101"><a href="del.asp">删除</a> <a href="xgxx.asp">修改</a></td>
</tr><% objrs.movenext
k=k+1
next
%>
</table>
<table width="627" height="22" border="1">
<%
DB="mysql.mdb"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DB)
objconn.open
strSQL = "SELECT * FROM admin"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSQL, objConn, 1, 3
i=objrs.recordcount '统计objrs中的数据个数
for k=1 to i %>
<tr>
<td width="154"><%=objrs("name")%></td>
<td width="106"><%=objrs("password")%></td>
<td width="238"><%=objrs("class")%></td>
<td width="101"><a href="del.asp">删除</a> <a href="xgxx.asp">修改</a></td>
</tr><% objrs.movenext
k=k+1
next
%>
</table>