libsys - 2014/5/12 0:43:19
今日文章：<span class="hs"><%=Get_Data("co","select count(id) as co from article where datediff('d',thedate,Now())=0")%></span><br>
如果改为2012年文章，代码该怎么写
如果改为2013-01-01到2014-03-03文章数代码该怎么写
xiyou - 2014/5/12 10:35:26
sql数据库：<%=Get_Data("co","select count(id) as co from article where thedate between '2013-01-01' and '2014-03-03'")%>
如果用access数据库：<%=Get_Data("co","select count(id) as co from article where thedate between #2013-01-01# and #2014-03-03#")%>