淘先锋技术网

首页 1 2 3 4 5 6 7
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']; //这个是数量}