<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
</head>

<body background="../image/index_nj_r1_c2.gif" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="326" height="140" border="0" cellpadding="0" cellspacing="0">
    <%
set rs=server.createobject("adodb.recordset")
sql="SELECT  * FROM Special where IsGood=1 order by Specialid desc"
rs.Open sql,conn,1,1
b=0
			do while not rs.eof
			b=b+1
%>
  <tr>
    <td width="90"><div align="center"><a href="MusicList.asp?AlbumID=<%=rs("SpecialID")%>"> 
        <img height="80" src="<%=rs("pic")%>" width="80" border="0" style="border: 1px solid #000000"></a></div></td>
    <td width="236"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber15" height="37">
        <tr> 
          <td width="8%" height="37" rowspan="2">&nbsp;</td>
          <td width="92%" height="22"> <font color="#0066CC">NJÐÕÃû£º</font><%=rs("NClass")%></td>
        </tr>
        <tr> 
          <td width="92%" height="15"> <font color="#0066CC">½ÚÄ¿Ãû³Æ£º</font><a href="MusicList.asp?AlbumID=<%=rs("SpecialID")%>"><%=rs("name")%></a></td>
        </tr>
        <tr> 
          <td width="100%" height="10" colspan="2"> 
            <%
if len(rs("intro"))>120 then
response.write (left(rs("intro"),120))
else
response.write (rs("intro"))
end if
%>
            ......</td>
        </tr>
      </table></td>
  </tr>
  <%
                            if b>=1 then exit do
  rs.movenext      
loop   %>
</table>
</body>
</html>
