产品使用及交流论坛

注册

 

QQ登录

只需一步,快速开始

发新话题 回复该主题

xiyou帮我看下datediff是什么问题 [复制链接]

1#
<html>
<head>
<style type="text/css">
div{font:12px/1.7em Verdana,Tahoma,Helvetica,Arial,sans-serif;}
div .hs{colorff0000}
</style>
</head>
<body bgColor="transparent">
<div>
○- 文章总数:<span class="hs"><%=Get_Data("co","select count(id) as co from article")%></span><br>
○- 今日文章:<span class="hs"><%=Get_Data("co","select count(id) as co from article where datediff('day',thedate,GETDATE())=0")%></span><br>
○- 会员总数:<span class="hs"><%=Get_Data("co","select count(id) as co from pa_member")%></span><br>
○- 最新会员:<span class="hs"><%=Get_Data("username","select top 1 username from pa_member order by id desc")%></span><br>
○- 访问总数:<span class="hs"><%=Get_Data("co","select count(id) as co  from pa_count")%></span><br>
○- 本月访问:<span class="hs"><%=Get_Data("co","select count(id) as co  from pa_count where datediff('m',thedate,GETDATE())=0")%></span><br>
○- 今日访问:<span class="hs"><%=Get_Data("co","select count(id) as co  from pa_count where datediff('day',thedate,GETDATE())=0")%></span><br>
</div>
</body>
</html>
分享 转发
TOP
2#

你是用sql吗?如果使用sql
datediff('m' , datediff('day'这些地方不要带单引号,这是access数据库的写法
sql按下面方式修改
datediff('m' 改为datediff(month
datediff('day'改为datediff(day
TOP
3#

谢谢xiyou搞定了
TOP
发新话题 回复该主题