mysql查詢一周內(nèi)每天的記錄數(shù)？

$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']; //這個(gè)是數(shù)量}