<%
T=request("T")
Y=request("Y")
G=request("G")
Q=request("Q")
set rs=server.createobject("adodb.recordset")
'sql="SELECT top 30 * from down where 1=1 order by id desc"
if T<>"" then
sql="SELECT top 30 cxn,id,pic,hits from down where cd='音乐MTV' and show=1 order by date desc"
elseif Y<>"" then
sql="SELECT top 30 cxn,id,pic,hits from down where cd='在线游戏' order by date desc"
elseif G<>"" then
sql="SELECT top 30 cxn,id,pic,hits from down where cd='音乐MTV' order by cxn asc"
elseif Q<>"" then
sql="SELECT top 30 cxn,id,pic,hits from down where show=1 order by date asc"
else
sql="SELECT top 30 cxn,id,pic,hits from down where cd='音乐MTV' and show=1 order by date desc"
end if
rs.open sql,conn,1,1
%>
<%
i=0
do while not rs.eof or rs.bof
%>|
|
<%
i=i+1
if i mod 5 =0 then response.write" "
rs.MoveNext
loop
rs.close:set rs=nothing
%>
|
 |
|
|