<%
Dim MusicID,MusicArray,MusicNum,songpath
MusicID=request.QueryString("id")
'创建排列顺序
MusicArray=Split(MusicID, ",")
MusicNum = UBound(MusicArray)
set rs=server.createobject("adodb.recordset")
For i=0 To MusicNum
sql="select Musicname,Wma,Singer,song_path from [MusicList] where id ="&MusicArray(i)
rs.open sql,conn,1,1
If not rs.eof Then
songpath=rs("song_path")
If songpath="" or IsNull(songpath) Then
songpath=1
End If
Select Case songpath
Case 1
song_path=song_path1
Case 2
song_path=song_path2
Case 3
song_path=song_path3
Case 4
song_path=song_path4
Case 5
song_path=song_path5
Case 6
song_path=song_path6
Case 7
song_path=song_path7
Case 8
song_path=song_path8
Case 9
song_path=song_path9
Case 10
song_path=song_path10
Case 11
song_path=song_path11
Case 12
song_path=song_path12
Case 13
song_path=song_path13
Case 14
song_path=song_path14
Case 15
song_path=song_path15
Case 16
song_path=song_path16
Case 17
song_path=song_path17
Case 18
song_path=song_path18
Case 19
song_path=song_path19
Case 20
song_path=song_path20
Case 21
song_path=song_path21
Case 22
song_path=song_path22
Case 23
song_path=song_path23
Case 24
song_path=song_path24
Case 25
song_path=song_path25
Case 26
song_path=song_path26
Case 27
song_path=song_path27
Case 28
song_path=song_path28
Case 29
song_path=song_path29
Case 30
song_path=song_path30
Case 31
song_path=song_path31
Case 32
song_path=song_path32
Case 33
song_path=song_path33
Case 34
song_path=song_path34
Case 35
song_path=song_path35
Case 36
song_path=song_path36
Case 37
song_path=song_path37
Case 38
song_path=song_path38
Case 39
song_path=song_path39
Case 40
song_path=song_path40
Case else
song_path=song_path1
End Select
song_path=song_path&rs("Wma")
%>
<%=rs("Musicname")%>免费影院免费影院免费影院www.xxxxxx.com "/> "/>
<%
End If
rs.close
Next
set rs=nothing
CloseDatabase
%>
<%
Dim MusicID
MusicID=trim(request.QueryString("id"))
If MusicID="" Then
Response.Write ("<script language=JavaScript>alert('错误!\n\n您至少需要选择一部影片');javascript:window.close();</script>")
Response.end
End If
'更新点击量
'conn.execute("update [MusicList] set hits=hits+1 where id in ("&MusicID&")")
'创建排列顺序
MusicArray=Split(MusicID, ",")
MusicNum = UBound(MusicArray)
set rs=server.createobject("adodb.recordset")
For i=0 To MusicNum
sql="select MusicName,Singer,hits from MusicList where id ="&MusicArray(i)
rs.open sql,conn,1,3
If not rs.eof Then
rs("hits")=rs("hits")+1
rs.Update
MusicName=MusicName&", "&rs("MusicName")
Singer=Singer&", "&rs("Singer")
hits=hits&","&rs("hits")
End If
rs.close
Next
set rs=nothing
CloseDatabase
hits=Mid(hits,2)
Singer=Mid(Singer,3)
MusicName=Mid(MusicName,3)
%>