plus_dg.asp

学校网站管理系统

<!--#include file="inc/conn.asp"-->
<!--#include file="inc/set.asp"-->
<!--#include file="inc/dll.asp"-->
<!--#include file="inc/inc.asp"-->
<!--#include file="sqlx.asp"-->
<%
title="点播系统"
call pass()
call top()
%>
<table border="0"  cellspacing="0" cellpadding="0" align=center class=bgcolor>
<tr><td class=left></td><td>
<td class=width>
<table width=100% border=0  cellspacing="0" cellpadding="0">
<tr><td valign=top>
<br>
<table border="0"   cellspacing="0" cellpadding="0">
<td  class=lefttopcenter>&emsp;<img border=0 src='img/mor.gif' align=absmiddle> 会员登陆</td><td  class=lefttopright></td></tr></table>
<table border="0" cellspacing="0" cellpadding="0"><tr>
<td valign=top class=leftcentercenter  height=150 >
<%call login()%>
</td><td class=leftcenterright></td></tr></table>
<table border="0"  cellspacing="0" cellpadding="0"><tr><td class=leftfootcenter></td><td class=leftfootright></td></tr></table>
<br>
</td>
<td width="15"></td><td>
<table border="0" cellspacing="0" cellpadding="0">
<tr><td class=righttopleft></td>
<td class=righttopcenter><img border=0 src='img/mor.gif' align=absmiddle>点歌列表<span style='width=420px'></span><a href="javascript:openScript('plus_dgup.asp',200,160)" ><font color=#007100>点歌</font></a> - <a href=plus_dgplayer.asp><font color=#007100>连播</font></a></td></tr></table>
<table border="0"   cellspacing="0" cellpadding="0"><tr>
<td class=rightcenterleft></td>
<td  class=rightcentercenter valign=top height=60>
<table  width=100%  height=150 ><tr><td>
<marquee scrollamount=2 direction=up height=140 onmouseover=this.stop(); onmouseout=this.start();>
<%
sql="select * from YC_dg order by id DESC"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
do while not rs.eof%>
<table width=100%><tr><td><b>
<a href="plus_dgplayer.asp?id=<%=rs("id")%>" target=_blank><font size=4 color=orange><%=rs("sender")%></font> <font size=4>于</font> <font size=4 color=orange><%=rs("sendtime")%></font> <font size=4>为</font> <font size=4 color=orange><%=rs("incept")%></font> <font size=4>点了一首</font> <font size=4 color=orange>《<%=rs("musicname")%>》</font>，  
<font size=4>并祝福说：</font><font size=4 color=orange><%=rs("content")%></font></a></b></td></tr></table><br>
<%rs.movenext
loop
if rs.eof and rs.bof then%>没有祝福内容！<%end if
rs.close
set rs=nothing
%></marquee></td></tr></table></TD></TR></table>
<table border="0" cellspacing="0" cellpadding="0"><tr>
<td  class=rightfootleft></td><td class=rightfootcenter></td></tr></table>
</td></tr></table>
</td><td class=right></td></tr></table>
<%call foot()%>