<!--#include file="conn.asp"--> 
<table border="0" cellpadding="0" cellspacing="0" width="99%" align="right">
  <% set rs=server.createobject("adodb.recordset")
sql="Select top 10 * from music where isgood=1 order by id Desc"
rs.open sql,conn,1,1 
if rs.eof and rs.bof then
%><li>沒有推薦作品<%else%>
    <tr > 
      <td width="98%" align="center"  background="image/tuijian.gif" height="49" colspan="2"></td>
  </tr>
  <%do while not rs.eof%> 
  <tr> 
    <td width="98%"> <a title="點擊：<%=rs("d")%>"  target="_blank" href="swfPlay.asp?id=<%=rs("id")%>"><%=Left(rs("name"),12)%></a> 
      <%if not rs("time") < date then%>
      &nbsp;<img border="0" src="IMAGE/NEW.gif" title="點擊排行中最新發(fā)布"> 
      <%end if%>
    </td>
    <td width="2%">
      <div align="right"><font color="#FF0000"><%=rs("d")%></font></div>
    </td>
  </tr>
  <%
	rs.movenext
	loop
	end if
	rs.close
%>
</table>