Hello, in my database table there are 6 records. But on my first page which retrieve the data from table need only 2 records. And on the second page, I need to show all the records from the table but in the form of 3 records in each line.
I have before
set rs=Server.CreateObject(“ADODB.recordset”)
sql=“select name from mytable”
rs.Open sql, conn
do until rs.EOF
Response.Write(rs(“name”))
rs.MoveNext
loop
But this will give all the records at the same time, how should I code so that for the first page, it can only output first two records. And on the second page, it can output in a form of 3 records in each line, so that there are two lines and 6 records altogether.
Thanks a lot in advance!