X antal visninger pr. side
Jeg har et script, som skal skrive nogle poster fra en database.men den skal kun vise det antal som brugeren putter ind i formularen ...
Er der en der gider at hjjælpe mig ??
Her er Scriptet :
<%stat = request.form("stat")
'Antal resultater pr. side
reprside = request.form("antal")
%>
<html>
<head>
<title></title>
</head>
<body bgcolor="#903636" text="#FFFFFF">
<form action="stat.asp" method="post">
<img src="ipnummer.jpg"><input type="radio" name="stat" value="ip"> <img src="dato.jpg"><input type="radio" name="stat" value="dato"> <img src="referencer.jpg"><input type="radio" name="stat" value="ref">
<input type="text" name="antal" Value="10">
<input type="Submit" value="Valg">
</form><br>
<%
Set Conn = Server.CreateObject("ADODB.connection")
Conn.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=db.mdb"
sql1 ="select * from tbl_track where ((ID)<(" & reprside & "))order by Ip"
set rs = conn.execute(sql1)
response.write rs.RecordCount & "<br>"
response.write rs.pageCount & "<br>"
response.write pageNo & "<br>"
TotalRows = rs.RecordCount
rs.PageSize = reprside
TotalPages = rs.PageCount
Session("page_num") = PageNo
select case request.QueryString("move")
case "first" PageNo = 1
case "previous" PageNo = (Session("page_num")) - 1
case "next" PageNo = (Session("page_num")) + 1
case "last" PageNo = TotalPages
end select
if PageNo < 1 then PageNo = 1
if PageNo > TotalPages then PageNo = TotalPages
%>
<table>
<tr><td>Bruger Nr. :</td><td>Bruger Ip :</td><td>Brugerens søgeord :</td><td>Sider Brugeren har set :</td><td>Tid for ankomst på side :</td></tr>
<%
x = 0
do until rs.eof
Response.write "<tr>"
Response.Write "<td bgcolor='silver'><font face='verdana' size='2'>" & rs("UserID") & "</td><td bgcolor='silver'>" & rs("IP") & "</td><td bgcolor='silver'>" & rs("soegeord") & "</td><td bgcolor='silver'>" & rs("side") & "</td><td bgcolor='silver'>" & rs("tid") & "</td></tr>"
x = x + 1
rs.MoveNext
loop
reprside = reprside + reprside
%>
</table>
<a href="stat.asp?move=first">Start </a> - <a href="stat.asp?move=previous">Tilbage</a> - <a href="stat.asp?move=next">Frem</a> - <a href="stat.asp?move=last">Sidste</a>
</body>
</html>
