自己答了 select count(id) as cc from posts where timer>(UNIX_TIMESTAMP(CURRENT_DATE())) and timer<(UNIX_TIMESTAMP(CURRENT_DATE())+86400)select count(id) as cc from posts where timer>UNIX_TIMESTAMP(date_sub(curdate(),interval 1 day)) and timer<(UNIX_TIMESTAMP(date_sub(curdate(),interval 1 day))+86400)来接分吧
select count(id) as cc from posts where timer>(UNIX_TIMESTAMP(CURRENT_DATE())) and timer<(UNIX_TIMESTAMP(CURRENT_DATE())+86400)select count(id) as cc from posts where timer>UNIX_TIMESTAMP(date_sub(curdate(),interval 1 day)) and timer<(UNIX_TIMESTAMP(date_sub(curdate(),interval 1 day))+86400)来接分吧
[align=center]==== 思想重于技巧 ====
[/align]
.
贴子分数<20:对自已的问题不予重视。
贴子大量未结:对别人的回答不予尊重。
.