?? point.asp
字號:
<%@ LANGUAGE="VBSCRIPT" %>
<% option explicit%>
<!--#include file="newconn.asp"-->
<!-- #include file="inc/char.inc" -->
<!-- #include file="inc/tree.inc"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>積分</title>
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
<link rel="stylesheet" type="text/css" href="forum.css">
</head>
<body>
<%
dim rs
dim sql
dim Article
dim username
set rs=server.createobject("adodb.recordset")
sql="select * from user where username ORDER BY Article desc"
rs.open sql,conn,1,1
if rs.EOF then
response.write "not point"
else
%>
<div align='center'><center><table border='1' width='50%' cellspacing='0' bordercolorlight='#000000' bordercolordark='#FFFFFF' cellpadding='0'>
<tr>
<td width="100%" colspan="4" bgcolor='#FEEC85'><table border="0" width="100%" cellspacing="0"
cellpadding="0">
<tr>
<td width="100%" align="center"><b>論壇積分排行榜</b></td>
</tr>
</table>
</td>
</tr>
<tr>
<td align='center' width='25%'><b>姓名</b></td><td align='center' width='25%'><b>積分</b></td>
<td align='center' width='25%'><b>姓名</b></td><td align='center' width='25%'><b>積分</b></td></tr>
<%do while NOT rs.EOF%>
<tr>
<td align='center' width='25%'><%=rs("username")%></td>
<td align='center' width='25%'><font color=red><%=rs("Article")%></font></td>
<td align='center' width='25%'><%=rs("username")%></td>
<td align='center' width='25%'><font color=red><%=rs("Article")%></font></td>
</tr>
<%
rs.MoveNext
username=username+1
if username>9 then Exit Do
loop
end if
rs.Close
set rs=nothing
%>
</table></center></div>
<div align='center'><center><table border='0' width='50%' cellspacing='0' bordercolorlight='#000000' bordercolordark='#FFFFFF' cellpadding='0'>
<tr><td align='right'><a href='myinfo.asp?page=3' target="BoardAnnounce">查看個人積分>></a><a href='aboutpoint.asp' target="BoardAnnounce">關(guān)于積分>></a>
</td></tr>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -