Page count (Previous/next)

Hej allesammaen :-)

Hvordan gör jeg så at den henter frem den sidste post fra databasen og så har en knapper (next og previous), som bladrer til näste post eller tilbage?

<%
SQL = "SELECT * FROM DBEvent WHERE EventStatus = 1"
Set RecSet = Connect.Execute(SQL)
%>
<table height="160" width="260" border="0" cellpadding="3" cellspacing="0" class="Border">
    <tr>
        <td height="25" width="260" colspan="2" background="pictures/FrameSmall.gif"><div class="MainSubjectL"><font class="Font11B">Tidligare!</font></div></td>
    </tr>
    <tr>
        <td height="125" width="100">Bild</td>
        <td height="125" width="160"><font class="Font11N"><%=RecSet("EventSubject")%></font><br><hr><%=Left(RecSet("EventText2"),170)%></td>
    </tr>
    <tr>
        <td height="10" width="260" colspan="2" style="vertical-align: bottom"><img src="pictures/BorderVerSmaSolid.gif" border="0"><br><img src="pictures/ButtonPrevious.bmp" border="0">&nbsp;<img src="pictures/ButtonNext.bmp" border="0"></td>
    </tr>
</table>