$sql="select id,username,sex,qq,email,info,ip,DATE_FORMAT(submit_time,'%Y年%m月%d日%H时%i分%s秒') from lo order by id desc limit $offset,$pagesize"; 这个是代码,有错吗?
那不就对了 ,date 后面没有时分秒
select DATE_FORMAT(addtime,'%Y-%m-%d') as time,count(*) as countes from `表名` group by time
这个是代码,有错吗?