Frem og tilbage i tabelen
jeg har en tagwall der kun viser 10 poster ad gangen jeg vil gerne have nede i bunden af siden så man kan gå frem og tilbage i siderne....her er min kildekode hvis der er en der vil være sød og smide det ind på den:
<!--#include file=\"setup.asp\"-->
<%
function smileys(smil)
smil = Replace(smil, \":)\", \"<img width=15 height=15 border=0 src=\"\"smileys/smiley-happy.gif\"\">\")
smil = Replace(smil, \";)\", \"<img width=15 height=15 border=0 src=\"\"smileys/wink.gif\"\">\")
smil = Replace(smil, \":(\", \"<img width=15 height=15 border=0 src=\"\"smileys/angry.gif\"\">\")
smil = Replace(smil, \":D\", \"<img width=15 height=15 border=0 src=\"\"smileys/biggrin.gif\"\">\")
smil = Replace(smil, \":P\", \"<img width=15 height=15 border=0 src=\"\"smileys/biggrin2.gif\"\">\")
smil = Replace(smil, \":}\", \"<img width=15 height=15 border=0 src=\"\"smileys/tongue.gif\"\">\")
smil = Replace(smil, \";o\", \"<img width=15 height=15 border=0 src=\"\"smileys/redface.gif\"\">\")
smil = Replace(smil, \";}\", \"<img width=15 height=15 border=0 src=\"\"smileys/smiley8.gif\"\">\")
smileys = smil
end function
%>
<html>
<head>
<title><% Response.Write title %></title>
</head>
<body>
<%
Response.Write \"<div align=center><a href=tag.asp>Nyt Tag</a>\" & \" <a href=admin/default.asp>Admin</a>\" & \"<br><br><br><br>\"
tempConn = \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"tagwall.mdb\") & \";UID=admin;PWD=;\"
Set myConn = Server.CreateObject(\"ADODB.Connection\")
Nyhed = \"SELECT top 10 * FROM tagwall ORDER BY ID DESC;\"
myConn.Open tempConn
Set rs = myConn.Execute(Nyhed)
If Not (rs.BOF Or rs.EOF) Then
Do While Not rs.EOF
Response.Write \"<table border=1 width=350 cellpadding=0 cellspacing=0 bordercolor=#000000>\" & \"<tr>\" & \"<td>\" & \"Navn: \"
Response.Write \"</td>\" & \"<td> \" & rs(\"navn\") & \" </td>\" & \"</tr>\"
Response.Write \"<tr><td>E-Mail: </td><td> <a href=mailto:\" & rs(\"email\") & \">\" & \"<img border=0 src=mail.gif alt=\" & \"Send en mail til \" & rs(\"navn\") & \">\" & \"</a> </td></tr>\"
Response.Write \"<tr><td>Hjemmeside: </td><td> <a href=\" & rs(\"hp\") & \">\" & \"<img border=0 src=hp.gif alt=\" & \"Gå til \" & rs(\"hp\") & \">\" & \"</a> </td></tr>\"
Response.Write \"<tr><td>\" & \"Tekst: \" & \"</td><td> \" & (smileys(rs(\"tag\")))
Response.Write \"</td></tr></table><br><br>\"
rs.MoveNext
Loop
Else
Response.Write \"<p>No Tags!!!!</p>\"
End If
Response.Write \"</div>\"
myConn.Close
Set myConn = Nothing
%>
</body>
</html>
På Forhånd TAK!!
-Mascot-
