<%
i=0
MaxList=201
set rs=server.createobject("adodb.recordset")
sql="select top "&MaxList&" id,Nclassid,musicName,Singer FROM MusicList where sclassid=2 order by z_hits 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
%>