<%
i=0
MaxList=6
set rs=server.createobject("adodb.recordset")
sql="SELECT top 6 Name,Nclass,SpecialID,Pic,Nclassid,SpecialID,Yuyan FROM Special where IsGood=-1 order by Specialid desc"
rs.Open sql,conn,1,1
do while not rs.eof
i=i+1
%>
<%
if i>=MaxList then exit do
rs.movenext
loop
rs.close
%>
<%
i=0
MaxList=6
set rs=server.createobject("adodb.recordset")
sql="SELECT top 6 Name,Nclass,SpecialID,Pic,Nclassid,SpecialID,Yuyan FROM Special where sclassid=1 and IsGood=-1 or sclassid=2 and IsGood=-1 or sclassid=3 and IsGood=-1 order by Specialid desc"
rs.Open sql,conn,1,1
do while not rs.eof
i=i+1
%>
<%
if i>=MaxList then exit do
rs.movenext
loop
rs.close
%>
<%
i=0
MaxList=6
set rs=server.createobject("adodb.recordset")
sql="SELECT top 6 Name,Nclass,SpecialID,Pic,Nclassid,SpecialID,Yuyan FROM Special where sclassid=4 or sclassid=5 or sclassid=6 order by Specialid desc"
rs.Open sql,conn,1,1
do while not rs.eof
i=i+1
%>
<%
if i>=MaxList then exit do
rs.movenext
loop
rs.close
%>
<%
i=0
MaxList=6
set rs=server.createobject("adodb.recordset")
sql="SELECT top 6 Name,Nclass,SpecialID,Pic,Nclassid,SpecialID,Yuyan FROM Special where sclassid=7 order by Specialid desc"
rs.Open sql,conn,1,1
do while not rs.eof
i=i+1
%>
<%
if i>=MaxList then exit do
rs.movenext
loop
rs.close
%>
<%
i=0
MaxList=6
set rs=server.createobject("adodb.recordset")
sql="SELECT top 6 Name,Nclass,SpecialID,Pic,Nclassid,SpecialID,Yuyan FROM Special where sclassid=8 or sclassid=9 or sclassid=10 or sclassid=11 or sclassid=12 or sclassid=13 or sclassid=14 or sclassid=15 order by Specialid desc"
rs.Open sql,conn,1,1
do while not rs.eof
i=i+1
%>
<%
if i>=MaxList then exit do
rs.movenext
loop
rs.close
%>
