php - codeigniter 中的 group by 和 count 计数不正确

Question

我在显示正确的计数(字段)数量时遇到问题。我正在尝试按字段进行分组，并希望按组和计数返回订单。

Controller 是

    $this->load->library('pagination');

    $query = "SELECT usercode,count(usercode) AS co FROM tabs
    GROUP BY usercode ORDER BY co desc";

    $config['total_rows'] = $this->db->query($query)->num_rows();
    $config['num_links'] = '25';
    $config['uri_segment'] = 3;
    $config['base_url'] = base_url() . "/user/topCreators/";
    $config['per_page'] = '25';
    $config['anchor_class'] = " class=\"number\" ";
    $config['cur_tag_open'] = "<a href=\"#\" class=\"number 
    current\" title=\"Current Page\">";
    $config['cur_tag_close'] = "</a>";

    $this->pagination->initialize($config);
    if ($this->uri->segment(3) == FALSE){
        $offset = 0;
    }
    else
    {
        $offset = $this->uri->segment(4);
    }

    $limit = $config['per_page'];
    $data["total_records"] = $config['total_rows'];
    $data["page_links"] = $config["per_page"];


    $data["query"] = $this->db->query($query . " LIMIT $limit OFFSET $offset");

    $this->load->view("top_creators", $data);

我的 View 文件是

   <?php foreach($query->result() as $me) {?>
   <?= $me->co?>  

   <?php }?>

Answer 1

co 对于每个结果来说都是相同的数字，因为您正在对表选项卡中的所有用户代码进行计数，因此您的排序将不起作用。它还使得执行 $this->db->query($query)->num_rows(); 变得多余，因为它与 co

的值相同