php - 我怎样才能在codeigniter中按降序排列月份

Question

我正在尝试在 codeigniter 和 mysqli 中订购按月递减的销售额。目前我正在获取这样的数据：

请帮我在检查代码后订购几个月。

public function sale(){
    if($this->ion_auth->in_group('admin') || $this->ion_auth->in_group('accounts')){
        $this->load->view('partials/header');
        $this->load->view('partials/menu');
        $query =  $this->db->query("SELECT COUNT(`id`) as `count` ,SUM(`price`) as `price_count`,MONTHNAME(`created`) as `month_name` FROM `sales` WHERE YEAR(`created`) = '" . date('Y') . "'
                GROUP BY YEAR(`created`),MONTH(`created`) DESC"); 

            $record = $query->result();

            $output = [];
            foreach($record as $row) {
                $output[] = array(
                 'month_name'   => $row->month_name,
                 'count'  => floatval($row->count),
                 'price_count' => floatval($row->price_count),
                );
            }
        $data['output'] = ($output);
        $this->load->view('reports/sales', $data);
        $this->load->view('partials/footer');
    } else {
        redirect(base_url().'404');
    }
}

标签： phpcodeigniter

Answer 1

$query =  $this->db->query("SELECT COUNT(`id`) as `count` ,SUM(`price`) as `price_count`,MONTHNAME(`created`) as `month_name` FROM `sales` WHERE YEAR(`created`) = '" . date('Y') . "'
                GROUP BY YEAR(`created`),MONTH(`created`) ORDER BY created DESC");