%
Dim iPageSize, iThisPage, iCount
iPageSize=5
iCount = 0
dim nstart
dim startrow
dim endrow
dim i
if request("nstart")="" then
nstart=0
startrow=1
endrow=3'
else
if request("val")="prev" then
nstart=request("nstart")-6'
startrow=request("startrow")+1
endrow=request("endrow")-6'
else
nstart=request("nstart")+6'
startrow=request("startrow")-1
endrow=request("endrow")+6'
end if
end if
%>
<%
SET rsFea = server.CreateObject("adodb.recordset")
rsFea.Open "SELECT * FROM main WHERE (Featured = 1)",DBConn,1,3
if not rsFea.EOF then
rsFea.move(nstart)
end if
for i=0 to 5
%>