网站程序如何读取一周之内的数据
一周内的
sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())<=7"
昨天
sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())=1"
今天
sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())=0
一周内的
sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())<=7"
昨天
sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())=1"
今天
sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())=0