mysql 一周_mysql查询一周内每天的记录数。

自己写的查询语句，目的就是统计这一周每天的记录数有多少条。感觉这样写的方法好像有点笨吧。有什么好的办法没。 $count1=mysql_num_rows(mysql_query("SELECT*FROMmembersWHER...

自己写的查询语句，目的就是统计这一周每天的记录数有多少条。感觉这样写的方法好像有点笨吧。有什么好的办法没。 $count1= mysql_num_rows(mysql_query("SELECT * FROM members WHERE TO_DAYS( NOW( ) ) - TO_DAYS( regtime)=6"));$count2= mysql_num_rows(mysql_query("SELECT * FROM members WHERE TO_DAYS( NOW( ) ) - TO_DAYS( regtime)=5"));$count3= mysql_num_rows(mysql_query("SELECT * FROM members WHERE TO_DAYS( NOW( ) ) - TO_DAYS( regtime)=4"));$count4= mysql_num_rows(mysql_query("SELECT * FROM members WHERE TO_DAYS( NOW( ) ) - TO_DAYS( regtime)=3"));$count5= mysql_num_rows(mysql_query("SELECT * FROM members WHERE TO_DAYS( NOW( ) ) - TO_DAYS( regtime)=2"));$count6= mysql_num_rows(mysql_query("SELECT * FROM members WHERE TO_DAYS( NOW( ) ) - TO_DAYS( regtime)=1"));$count7= mysql_num_rows(mysql_query("SELECT * FROM members WHERE TO_DAYS( NOW( ) ) - TO_DAYS( regtime)=0"));

展开