sql - Order_by 不起作用

Question

我有这个查询，但是当输出显示它未排序时

function get_productbyid($productid) {
        $this->db->select('*')->from('projquotedetails,products')
                              ->where(array('projquotedetails.productid' => $productid))
                              ->where('projquotedetails.productid = products.productid')
                              ->order_by('page_order','asc')
                              ;

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

        if ($query->num_rows() > 0) { return $query->result_array(); }
        else                        { return 0; }

    }

标签： sqlcodeignitersql-order-by

Answer 1

询问 ：：

     function get_productbyid($productid) {
    $this->db->select('*')->from('projquotedetails,products')
                          ->where(array('projquotedetails.productid' => $productid))
                          ->where('projquotedetails.productid = products.productid')
                          ->order_by('projquotedetails.page_order','asc')
                          ;

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

    if ($query->num_rows() > 0) { return $query->result_array(); }
    else                        { return 0; }

}