需要完全SQL吗? 如果不是:先用PHP算出时间范围 $time1=mktime(0,0,0,date('d'),date('m'),date('Y'));//本日 $time1=strtotime("Sunday");//本周 $time1=mktime(0,0,0,1,date('m'),date('Y'));//本月$sql = "SELECT sum(point) AS point, uid FROM table where time>$time1 GROUP BY uid ORDER BY point DESC LIMIT 3";
如果不是:先用PHP算出时间范围
$time1=mktime(0,0,0,date('d'),date('m'),date('Y'));//本日
$time1=strtotime("Sunday");//本周
$time1=mktime(0,0,0,1,date('m'),date('Y'));//本月$sql = "SELECT sum(point) AS point, uid FROM table where time>$time1 GROUP BY uid ORDER BY point DESC LIMIT 3";
$time1=strtotime("Sunday");
$time1=mktime(0,0,0,date('m'),1,date('Y'));这样就对了