Onclick movenext

suppose if you have a 2 fields. one of them is Football's Celebrities Names and second one is their its.
four records
table tblfootball
1   Beckham
2   Ronaldo
3   Zidane
4   Batistuta

If you give <a href="<%rs.movenext%>">Click Here</a>
then it shows <a href="beckham"> Click Here </a>

simply make a
sql = "select * from tblfootball"

if rs.BOF = true then
 do nothing
else
 rs.MovePrevious
 strPrevious = "< a href=""" & rs.fields(1) & """> Previous </a>"
end if

rs.movenext
response.write rs.fields(0)
****Result Would Be *****
Beckham
*** End Result ***

if rs.EOF = true then
 do nothing
else
 rs.movenext
 strNext = "<a href=""" & rs.fields(1) & """> Next </a>"
End if

response.write strPrevious & " &nbsp; &nbsp; " & strNext
************* Expected Result **************
shows not next button like this
<a href="yourpage.asp?FID=2"> Next </a>
and the Id 2 is belong to Ronaldo
***************************************
remind u the next record is fetched from database by id
do alter in ur query
if request.querystring("FID") = "" then
sql = "select * from tblfootball"
else
sql = "select * from tblfootball where id =" & request.querystring("FID") ""
end if