blogtopuser.asp

来自「zheng fu wang zhan gong neng qi quan」· ASP 代码 · 共 19 行

<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="70%" id="AutoNumber3" height="52">
	<%set rs10=server.createobject("adodb.recordset")
	sql10="select top " & topuser & " * from "& db_User_Table &" where number>=1 order by number desc," & db_User_Id &" desc"
	rs10.open sql10,ConnUser,1,1
	if not rs10.EOF then
	while not rs10.EOF
	%>
	<tr>
		<td align="left" width="75%"><a href="Bloguser.asp?user=<%=rs10(db_User_Name)%>" target="_blank" class=class><%=rs10(db_User_Name)%></a></td>
		<td align="right" width="25%"><%=rs10("number")%></a></td>
	</tr>
	<%rs10.MoveNext
	wend
	end if
	rs10.close
	set rs10=nothing
	%>

</table>