How To View Data Separate

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi there..i need some help

this is the code:

<html>
<body>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("users.mdb")
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT  USERNAME, TOPIC FROM usercomment"
rs.Open sql, conn
%>
</div>
<table width="50%" border="1" align="center" bgcolor="#CCCCCC">
  <tr>
  <%for each x in rs.Fields
     response.write("<th align='center' bgcolor='#b0c4de'>" & x.name & "</th>")
  next%>
  </tr>
  <%do until rs.EOF%>
    <tr>
    <%for each x in rs.Fields%>
      <td><%Response.Write(x.value)%></td>
    <%next
    rs.MoveNext%>
    </tr>
  <%loop
  rs.close
  conn.close%>
</table>
</body>
</html>

This code will bring the result where all the data show in one table..i want the data show one by one but still in the same page and how to set the data so that the data only show 10 records in one page..
Please somebody help me...