表user   自动编号id  我想统计出有多少会员可是有语法错误？？？？？？？？？？？？？？
sql="select count(*) As id from user"
'set rs = conn.execute(sql)
rs.Open (sql),conn,1,1
Totaluser = rs("id")
rs.close


我统计歌曲都可以
sql="select count(*) As ID from MusicList"
'set rs = conn.execute(sql)
rs.Open (sql),conn,1,1
TotalMusicList = rs("ID")
rs.close   这个可以统计出而上面的不行



还请大虾们指教！！！！！！！！！！！

你这句是什意思。。rs.Open (sql),conn,1,1死我活 ？
要不你把完整的代码发出来看一下

把完整的代码发出来看一下

<%
SET rs = Server.CreateObject("ADODB.Recordset")
sql="select count(*) As NClassID from NClass"
'set rs = conn.execute(sql)
rs.Open (sql),conn,1,1
TotalNClass = rs("NClassid")
rs.close
sql="select count(*) As SpecialID from Special"
'set rs = conn.execute(sql)
rs.Open (sql),conn,1,1
TotalSpecial = rs("Specialid")
rs.close
sql="select count(*) As MusiclistID from Musiclist"
'set rs = conn.execute(sql)
rs.Open (sql),conn,1,1
TotalMusiclist = rs("Musiclistid")
rs.close
sql="select count(*) As ID from myuser"
'set rs = conn.execute(sql)
rs.Open (sql),conn,1,1
Totalmyuser = rs("id")
rs.close
rs.Open ("select sum(hits) from Musiclist"),conn,1,1
all_count=rs(0)
rs.Close
conn.Close
set rs=nothing
set conn=nothing
n=Year(date())
y=Month(date())
r=Day(date())
%>
共有歌手：<b><%=TotalNClass%></b>位&nbsp&nbsp
共有专辑：<b><%=TotalSpecial%></b>张&nbsp&nbsp
共有歌曲：<b><%=TotalMusiclist%></b>首&nbsp&nbsp
共有会员：<b><%=Totalmyuser%></b>位&nbsp&nbsp
累计点播数：<font color='#FF00FF'><%=all_count%></font>次&nbsp&nbsp