这句查询语句大家能看懂吗？str=replace(str,"$TodayVisitNums$",Conn.ExeCute("SelectCOUNT(counID)FROMblogCounterWhereYear(counTime)=Year(Now)andMonth(counTime)=Month(Now)andDay(counTime)=Day(Now)")(0))

Question

这句查询语句大家能看懂吗？str=replace(str,"$Today_VisitNums$",Conn.ExeCute("Select COUNT(coun_ID) FROM blog_Counter Where Year(coun_Time)=Year(Now) and Month(coun_Time)=Month(Now) and Day(coun_Time)=Day(Now)")(0))

Answer 1

select count(*) from 表名 这个是查询表的所有记录数 Where Year(coun_Time)=Year(Now) and Month(coun_Time)=Month(Now) and Day(coun_Time)=Day(Now)") 年月日和今天的匹配 这个你不是不知道吧$Today_VisitNums$ 我想应该是个标签 用在HTML模板里的 replace 是替换 吧这个标签替换为查询结果