mysql - 单列的代码点火器总和查询

Question

有一个查询，我试图返回值超过 10,000 的列的总和结果。我试过将 sum(value) 作为总计添加到查询中，但它不起作用。

我的代码是:

    $this->db->select('sum(value) as total, date, member_id');
    $this->db->where('member_id', $_SESSION['sess_user_id']);
    $this->db->where('cost.value >', '9999');
    $this->db->where('cost.date = DATE_SUB(NOW(), INTERVAL 5 DAY)');

    $query = $this->db->get('orders');

    return $query->num_rows();

这是原始 SQL 输出:

SELECT sum(value) as total，date，member_id FROM (steps) WHERE member_id = ' 1' AND cost.value > '9999' AND cost.date = DATE_SUB(NOW(), INTERVAL 5 天)

Answer 1

function cart_product_join()
    {
        $this->db->select('products.product_id,cart.product_id,SUM(products.special_price*cart.product_qty)');
        $this->db->from('products');
        $this->db->join('cart', 'cart.product_id = products.product_id', 'right');
        $result = $this->db->get()->result();
        return $result;
        //$result=$this->db->last_query();
        //echo $result;
    }