Paging i asp
Hej hvordan laver man en paging funktion til det her script?<%
if postnr <> "" then
SQL = "SELECT * FROM dh_firmaer WHERE fag="&Request.QueryString("id")&" AND postnr = "&postnr&" ORDER by name asc"
else
SQL = "SELECT * FROM dh_firmaer WHERE fag="&Request.QueryString("id")&" ORDER by name asc"
end if
Set rs = Conn.Execute(SQL)
Do While Not rs.EOF
%>
<table border="0" width="100%" class="firmatable" cellspacing="0" cellpadding="0">
<tr>
<td class="firmaheader"><%=rs("name")%></td>
</tr>
<tr>
<td class="firmacontent">
<%=rs("adress")%><br>
<%=rs("postnr")%> <%=rs("city")%><p></p>
Tlf.: <%=rs("phone")%>
</td>
</tr>
</table>
<br>
<%
RS.MoveNext
Loop
rs.close
%>
Håber der er nogen der kan hjælpe..
Ps.
Det er en mysql database..
