mysql查询一周内每天的记录数 – 数据库 – 前端 mysql中怎么使某字段自增

$re = mysql_query(“SELECT count(*) as n, (TO_DAYS( NOW( ) ) – TO_DAYS( regtime)) as `d` FROM members group by TO_DAYS( regtime) having d ‘; echo $rc[‘n’]; //这个是数量}