$user_info = M('user_info');
$map['create_time']=array(between,array("2014-01","2015-9"));
$result['usercount_list'] = $user_info->where($map)->field("date_format(create_time,'%Y-%m-%d') as times,count(*) as num")->group('times')->order('times desc')->page($page,$page_count)->select();
程序走到这里是正确的;然后做统计就要报错误,没有times列,我的目的只是获取没有分页前的条件结果条数。
$result['count'] = $user_info->where($map)->field("date_format(create_time,'$count_style') as times,count(*) as num")->group('times')->order('times desc')->count();
最佳答案