2-1sort.asp

971音乐站全站程序

<%PageName="1-1sort"%>
<!--#include file="function.asp"-->
<%CheckAdmin1%>
<!--#include file="conn.asp"-->
<!--#include file="top.asp"-->
<%
dim i
i=0 
MaxList=80
set rs=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")
%>
     <div align="center">
      <center>
      <table border="1" width="90%" cellspacing="0" cellpadding="0" class="TableLine" bordercolor="#A4CEE4" bordercolordark="#FFFFFF">
        <tr>
          <td width="100%" height="20" bgcolor="#96C5DE" align=center><font color="white"><b>音 乐 分 类 管 理</b></font></td>
        </tr>
        <tr>
          <td width="100%" height="22" bgcolor="#A4CEE4" align=center>
                <div align="center">
                  <table border="0" cellpadding="0" cellspacing="0" width="100%">
                   <form method="POST" action="SClassSave.asp?act=add&Classid=<%=rs("Classid")%>" align="center">
                    <tr>
                      <td width="20%"><font color="#FFFFFF">&nbsp;&nbsp;↓所属站点</font></td>
                      <td width="40%"><font color="#FFFFFF">↓进入音乐分类列表</font></td>
                      <td width="40%"><font color="#FFFFFF">↓添加音乐分类</font></td>
                    </tr>
                   </form>
                  </table>
                </div>
           </td>
        </tr>
<%
do while not rs.eof
	i=i+1
%>  
		<tr>
          <td width="100%" height="25" align=left>
                <div align="center">
                  <table border="0" cellpadding="0" cellspacing="0" width="100%">
                   <form method="POST" action="SClassSave.asp?act=add&Classid=<%=rs("Classid")%>" align="center">
                    <tr>
                      <td width="20%">&nbsp;&nbsp;<a href=2-2sort.asp?id=<%=rs("Classid")%>><%=rs("Class")%></a></td>
                      <td width="40%"><a href=2-2sort.asp?id=<%=rs("Classid")%>><font color="#4D9CC8"><---进入管理音乐分类</font></a></td>
                      <td width="40%"><input type="text" name="SClass" size="15">&nbsp;&nbsp;<input style="color: #FFFFFF; background-color: #4D9CC8; border: 1px solid #FFFFFF" type="submit" value="添 加" name="B1"></td>
                    </tr>
                   </form>
                  </table>
                </div>
		  </td>
        </tr>
<%
	if (i mod (MaxList/2)=0) and i>=(MaxList/2) then
%>

<%
	end if
	if i>=MaxList then exit do
    rs.movenext
	loop
	rs.close
	%>
      </table>
     </center>
    </div>
<% 
set rs=nothing
conn.close
set conn=nothing
%>