Opdele sider

Det må være paginering du søger. Det kan du gøre som beskrevet her: http://activedeveloper.dk/artikler/default.asp?articleid=31

Jeg er dog ikke helt sikker på om det fungerer med en mySQL database... :|

<html><head>
<title>Paging af et recordset</title>
</head><body>

<%

Set Conn = Server.Createobject("ADODB.Connection")
Conn.Open "DRIVER={MySQL};SERVER=mysql1.unoeuro.com;PORT=3306;DATABASE=database;UID=user;PWD=password;"

intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
  intPage = 1
End If



set rs=conn.execute("select link from banner")

'rs.Open strSQL, strDSN, 1
'If Not (rs.BOF Or rs.EOF) Then
  rs.PageSize = 10
  rs.AbsolutePage = intPage
  intRecCount = rs.PageSize
  intPageCount = rs.PageCount
  Response.Write "<p><b>Side " & intPage & " af " & intPageCount & "</b></p>"
  Do While Not rs.EOF And intRecCount > 0
    Response.Write rs("Link") & "<br>"
  intRecCount = intRecCount - 1
  rs.MoveNext
  Loop
'End If
rs.Close
Set rs = Nothing

Response.Write "<p>Gå til side "
For intNum = 1 To intPageCount
  Response.Write "<a href=paging.asp?page=" & intNum & ">" & intNum & "</a> "
Next

Response.Write "<p>"
If Clng(intPage) > 1 Then
  Response.Write "<a href=paging.asp?page=" & intPage - 1 & ">&lt;&lt;</a>"
Else
  Response.Write "&lt;&lt;"
End If

Response.Write "&nbsp;"

If Clng(intPage) < Clng(intPageCount) Then
  Response.Write "<a href=paging.asp?page=" & intPage + 1 & ">&gt;&gt;</a> "
Else
  Response.Write "&gt;&gt;"
End If
%>

</body></html>

jeg kan ikke få det her til at virke, hvordan ville du stille det op?

fandt et der virker derinde... smid et svar

OK :)

Tak for point :)