<!--#include file="../conn/conn1.asp"-->
<!--#include file="inc.asp"-->
<%
dim id
id=replace(request("id")," ","")
if isnumeric(id)=0 or id="" then
response.write "非法ID参数你是猪啊,欠扁啊你!"
response.end
end if
set rs=server.createobject("adodb.recordset") 	  
sql="select * from songlist where articleid="&id&"" 
rs.open sql,conn,1,1
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
-->
</style>
<link href="../css/css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>

<body>
<table width="95%" border="0" align="center" cellpadding="2" cellspacing="1" class="border">
  <tr class="topbg">
    <td height="22" colspan="2"  align="center"><strong>歌 曲 管 理</strong></td>
  </tr>
  <tr class="tdbg">
    <td width="70" height="30" ><strong>管理导航：</strong></td>
    <td><a href="Admin_song.asp">歌曲管理首页</a>&nbsp;|&nbsp;<a href="add_song.asp">添加歌曲</a>&nbsp;| <a href="admin_lm.asp">歌手管理 </a></td>
  </tr>
</table>
<table cellspacing="2" cellpadding="0" border="0" width="90%" align="center">
  <form action="save_editsong.asp?id=<%=id%>" method="POST" name="myform">
  <tr>
    <td height="25">歌曲名称：</td>
    <td><input name="title" type="Text" class="smallinput" id="title" value="<%=rs("title")%>" size="50" maxlength="50">
        <span class="style1">*</span> </td>
  </tr>
  <tr>
    <td height="25">大类选择：</td>
    <td><select name="cdid" id="cdid">
      <%
      set rstype=server.createobject("adodb.recordset")
      sqltype="select * from cd"
      rstype.open sqltype,conn,1,1
      do while not rstype.eof
      if rs("cdid")=rstype("cdid") then
         sel="selected"
      else
         sel=""
      end if
      response.write "<option " & sel & " value='"+CStr(rstype("cdid"))+"' name=cdid>"+rstype("cdname")+"</option>"+chr(13)+chr(10)
      rstype.movenext
      loop
      rstype.close
    %>
        </select>      &nbsp;<span class="style1">*</span></td>
  </tr>
  <tr>
    <td height="25">歌手选择：</td>
    <td>    
      <select name="typeid" id="typeid">
        <%
      set rstype=server.createobject("adodb.recordset")
      sqltype="select * from type"
      rstype.open sqltype,conn,1,1
      do while not rstype.eof
      if rs("typeid")=rstype("typeid") then
         sel="selected"
      else
         sel=""
      end if
      response.write "<option " & sel & " value='"+CStr(rstype("typeid"))+"' name=typeid>"+rstype("type")+"</option>"+chr(13)+chr(10)
      rstype.movenext
      loop
      rstype.close
	  set rstype=nothing
    %>
            </select>      &nbsp;<span class="style1">*</span></td>
  </tr>
  <tr>
    <td height="25">推荐操作：</td>
    <td>      <input name="flag" type="radio" value="0" <%if rs("flag")=0 then Response.Write "checked" %>>
正常
<input type="radio" name="flag" value="1" <%if rs("flag")=1 then Response.Write "checked" %>> 
<span class="style1">推荐</span><input type="radio" name="flag" value="2" <%if rs("flag")=2 then Response.Write "checked" %>> 
<span class="style1">头条</span></td>
  </tr>
  <tr>
    <td height="25">flash地址：</td>
    <td><input name="flashurl" type="Text" class="smallinput" id="flashurl" value="<%=rs("flashurl")%>" size="50">
        <span class="style1">*</span></td>
  </tr>
  <tr>
    <td height="25">图片地址 ：</td>
    <td><input name="imgurl" type="Text" class="smallinput" id="imgurl" value="<%=rs("imgurl")%>" size="50">
选择头条应填写图片地址 </td>
  </tr>
  <tr>
    <td height="25">作者姓名 ： </td>
    <td><input name="zzname" type="Text" class="smallinput" id="zzname" value="<%=rs("zzname")%>" size="50" maxlength="50"></td>
  </tr>
  <tr valign="top">
    <td height="25" valign="middle">作者信箱 ： </td>
    <td valign="middle"><input name="mail" type="Text" class="smallinput" id="mail" value="<%=rs("mail")%>" size="50" maxlength="50"></td>
  </tr>
  <tr valign="top">
    <td height="25" valign="middle">作者主页 ： </td>
    <td valign="middle"><input name="zzweb" type="Text" class="smallinput" id="zzweb" value="<%=rs("zzweb")%>" size="50" maxlength="50"></td>
  </tr>
  <tr valign="top">
    <td height="25" valign="middle">添加时间 ： </td>
    <td valign="middle"><input name="dateandtime" type="Text" class="smallinput" id="dateandtime" value="<%=date()%>" size="50" maxlength="50"></td>
  </tr>
  <tr valign="top">
    <td>歌词或简介： </td>
    <td><textarea name="content" cols="50" rows="9" class="smallinput" id="textarea"><%=rs("content")%></textarea>      
    <font color="#FF0000">*</font> </td>
  </tr>
  <tr>
    <td width="18%" valign="top">
      <div align="right"></div></td>
    <td width="82%"><input type="submit" name="Submit" value="提交"> </td>
  </tr>
  </form>
</table>
</body>
</html>
