mysql - 如何在 codeigniter 中使用 order by 制作自定义 SQL

Question

我的代码在这里 Sql 查询:

$sql ="select * from products where status='1' AND country='5' AND product_price > "50" AND product_price <= "100" order by product_id desc";
$product=$this->db->query($sql)->result_array();

使用自定义 SQL 查看所有产品，但仍未按描述显示顺序。

Answer 1

试试这个:

$sql = "SELECT * FROM `products` WHERE `status`=1 AND `country`=5 AND `product_price` > 50 AND `product_price` <= 100 ORDER BY `product_id` DESC";
        $product = $this->db->query($sql)->result_array();