<%
sql ="select top 9 opus.suolue,opus.jiage,opus.bianhao,opus.shouchu,artist.name from opus,artist where opus.zuozheid=artist.id order by bianhao desc"
set rsnew=server.CreateObject("adodb.recordset")
rsnew.open sql,conn,1,1
sql ="select top 9 opus.suolue,opus.jiage,opus.bianhao,opus.shouchu,artist.name from opus,artist where opus.zuozheid=artist.id order by bianhao desc"
set rsnew1=server.CreateObject("adodb.recordset")
rsnew1.open sql,conn,1,1
sql ="select top 9 opus.suolue,opus.jiage,opus.bianhao,opus.shouchu,artist.name from opus,artist where opus.zuozheid=artist.id and jingpin order by bianhao desc"
set rsjing=server.CreateObject("adodb.recordset")
rsjing.open sql,conn,1,1
sql ="select top 9 opus.suolue,opus.jiage,opus.bianhao,opus.shouchu,artist.name from opus,artist where opus.zuozheid=artist.id and jingpin order by bianhao desc"
set rsjing1=server.CreateObject("adodb.recordset")
rsjing1.open sql,conn,1,1
%>
<%
set rs=nothing
rsjing.close
set rsjing=nothing
rsnew.close
set rsnew=nothing
rsnew1.close
set rsnew=nothing
conn.close
set conn=nothing
%>
