SELECT FLOOR((clicktime - $starttime) / (24 * 3600)) AS sn, clicktime, COUNT(*) AS clickcount".
" FROM ja_click WHERE clicktime >= '$starttime' AND clicktime <= " .($endtime + 86400).
" GROUP BY sn 最佳答案
SELECT FLOOR((clicktime - $starttime) / (24 * 3600)) AS sn, clicktime, COUNT(*) AS clickcount".
" FROM ja_click WHERE clicktime >= '$starttime' AND clicktime <= " .($endtime + 86400).
" GROUP BY sn