<!--#include file="inc.asp"-->
<!--#include file="check.asp"-->
<%
dim i
set rs=server.createobject("adodb.recordset")
set rs2=server.createobject("adodb.recordset")
sql="select * from class order by classid"
rs.open sql,conn,1,1
i=request("id")
if i="" then i=rs("Classid")
%>
<%do while not rs.eof
%>
<%rs.movenext
loop
rs.close
%>
<%sql="select * from class where classid="&i
rs.open sql,conn,1,1
if rs.eof then%>
<%
else
%><link rel="stylesheet" href="images/Admin_Style.css">
<body leftmargin="2" topmargin="0" marginwidth="0" marginheight="0">
<div align="center">
<center>

<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolordark="#FFFFFF" style="border-collapse:collapse;">
<tr>
<td width="100%" height="22" align=center class="topbg"><strong>歌 手 管 理</strong></td>
</tr><tr>
<td width="100%" height="22" class="tdbg" align=center>
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="100%" bordercolordark="#FFFFFF">
<tr>
<td width="20%">&nbsp;<b>↓所属音乐分类</b></td>
<td width="543">　</td>
</tr>
</table>
</div>
</td>
</tr>
<%
sql2="select * from SClass where Classid="&rs("Classid")&" order by Sclassid"
rs2.open sql2,conn,1,1
if rs2.eof then
%>
<%
else
j=0
do while not rs2.eof
j=j+1
%>

<tr>
<td width="100%" height="29" align=left>
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<form method="POST" action="" align="center">
<tr>
<td width="289">&nbsp;&nbsp;<a href='0hao_Geshou.asp?Classid=<%=rs("Classid")%>&SClassid=<%=rs2("SClassid")%>'><%=rs2("SClass")%></a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;←进入修改管理</td>
<td width="492"><a href='0hao_Geshou_Ade.asp?act=add&Classid=<%=rs("Classid")%>&SClassid=<%=rs2("SClassid")%>'><font color="red">往本类别添加歌手</font></a></td>
</tr>
</form>
</table>
</div>
</td>
</tr>
<%
rs2.movenext
loop
end if
rs2.close
%>
<%
end if
rs.close
%>
</table>
</center>
</div>
<%
set rs=nothing
set rs2=nothing
conn.close
set conn=nothing
%></body></html>