<%
if session("HappyMusicUser")<>"" then
set rs=conn.execute("SELECT * FROM user where UserName='"&session("HappyMusicUser")&"'")
if (rs.eof and rs.bof) or err.number<>0 then
%>
<% else%>
|
欢迎您:<%=session("HappyMusicUser")%>
<%
set TNSIrs=server.createobject("adodb.recordset")
TNSIsql="SELECT * FROM SendMusic where ForUser='"&session("HappyMusicUser")&"' and IsNew=true and ForUserDel=false"
TNSIrs.Open TNSIsql,conn,1,1
TotalNewSendIn=TNSIrs.recordcount
TNSIrs.close
%>
查看您(新收到<%=TotalNewSendIn%>点歌)
<%
TNSIsql="SELECT * FROM collection where UserName='"&session("HappyMusicUser")&"'"
TNSIrs.Open TNSIsql,conn,1,1
TotalNewSendIn=TNSIrs.recordcount
TNSIrs.close
set TNSIrs=nothing
%>
打开您的收藏夹(共<%=TotalNewSendIn%>首) |