无法读出数据 看看!!!
<% strconnection="driver={mysql odbc 3.51 driver};database=jtwgamedb;server=localhost;uid=root;password=
set adodataconn = server.createobject("adodb.connection")
adodataconn.open strconnection
strquery = "select * from playerattrib order by level desc"
set rs = adodataconn.execute(strquery)
if not rs.bof then
%>
<html dir=ltr>
<head>
<title>练级狂人榜</title>
<META NAME="ROBOTS" CONTENT="NOINDEX">
<META HTTP-EQUIV="Content-Type" content="text/html; charset=gb2312">
<META NAME="MS.LOCALE" CONTENT="ZH-CN">
</head>
<body bgcolor="#99CCFF" text="#000000">
<strong><font size="5" face="楷体_GB2312"><p align="center" /p>练级狂人榜TOP50</font></strong>
<TABLE COLSPAN=8 CELLPADDING=2 align=center BORDER=0 bordercolorlight="#000000" cellspacing="1">
<!-- BEGIN 列标题行 -->
<TR>
<TD ALIGN=left BGCOLOR="#66CCFF">
<p align="center">
<FONT STYLE="ARIAL NARROW" SIZE=2>排名</FONT>
</TD>
<TD ALIGN=CENTER BGCOLOR="#66CCFF">
<font size="2">玩家</font>
</TD>
<TD ALIGN=left BGCOLOR="#66CCFF">
<p align="center">
<FONT STYLE="ARIAL NARROW" SIZE=2>ID</FONT>
</TD>
<TD ALIGN=CENTER BGCOLOR="#66CCFF">
<FONT STYLE="ARIAL NARROW" SIZE=2>角色</FONT>
</TD>
<TD ALIGN=CENTER BGCOLOR="#66CCFF">
<font size="2">等级/轮回</font>
</TD>
<TD ALIGN=CENTER BGCOLOR="#66CCFF">
<font size="2">地图</font>
</TD>
</TR>
<%
i=0
do while not rs.eof
i=i+1
if rs("attribute")=2 then
shuxing="唐僧"
end if
if rs("attribute")=5 then
shuxing="八戒"
end if
if rs("attribute")=4 then
shuxing="猴子"
end if
if rs("attribute")=3 then
shuxing="沙僧"
end if
if rs("attribute")=1 then
shuxing="龙女"
end if
if rs("mapno")=1 then
maphere="五行山"
end if
if rs("mapno")=2 then
maphere="白骨山"
end if
if rs("mapno")=3 then
maphere="白骨洞"
end if
if rs("mapno")=4 then
maphere="白骨小洞"
end if
if rs("mapno")=5 then
maphere="号山"
end if
if rs("mapno")=6 then
maphere="莲花洞"
end if
if rs("mapno")=7 then
maphere="莲花小洞"
end if
if rs("mapno")=8 then
maphere="松花间"
end if
if rs("mapno")=9 then
maphere="火云洞"
end if
if rs("mapno")=10 then
maphere="车迟国"
end if
if rs("mapno")=11 then
maphere="三清观"
end if
if rs("mapno")=12 then
maphere="三清观1"
end if
if rs("mapno")=13 then
maphere="三清观2"
end if
if rs("mapno")=14 then
maphere="陈家庄"
end if
if rs("mapno")=15 then
maphere="冰河"
end if
if rs("mapno")=16 then
maphere="通天河"
end if
if rs("mapno")=17 then
maphere="通天河2"
end if
if rs("mapno")=18 then
maphere="花果山"
end if
if rs("mapno")=19 then
maphere="水帘洞"
end if
if rs("mapno")=20 then
maphere="水帘洞小洞"
end if
if rs("mapno")=21 then
maphere="火焰山1"
end if
if rs("mapno")=22 then
maphere="火焰山2"
end if
if rs("mapno")=23 then
maphere="芭蕉洞"
end if
if rs("mapno")=24 then
maphere="芭蕉小洞"
end if
if rs("mapno")=25 then
maphere="小雷音寺"
end if
if rs("mapno")=26 then
maphere="火枫林"
end if
if rs("mapno")=27 then
maphere="长安"
end if
if rs("mapno")=28 then
maphere="荣誉堂1"
end if
if rs("mapno")=29 then
maphere="荣誉堂2"
end if
%>
<TR>
<TD ALIGN=CENTER BGCOLOR="#f7efde">
<font size="2"><%=i%></font>
</TD>
<TD ALIGN=CENTER BGCOLOR="#f7efde">
<font size="2"><%=rs("name")%></font>
</TD>
<TD ALIGN=left BGCOLOR="#f7efde">
<p align="center">
<FONT STYLE="ARIAL NARROW" SIZE=2><%=rs("icq")%></FONT>
</TD>
<TD ALIGN=CENTER BGCOLOR="#f7efde">
<FONT STYLE="ARIAL NARROW" SIZE=2><%=shuxing%></FONT>
</TD>
<TD ALIGN=CENTER BGCOLOR="#f7efde">
<font size="2"><%=rs("level")%></font>
</TD>
<TD ALIGN=CENTER BGCOLOR="#f7efde">
<font size="2"><%=maphere%></font>
</TD>
</TR>
<%
if i>=50 then exit do
rs.movenext
loop
%>
</table>
<%
else
response.write("未找到数据.")
end if
rs.close
adodataconn.close
set adodataconn = nothing
set rsemaildata = nothing
%>