My code is here SQL query:
$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(); It returns all products by using customs SQL but still not showing order by desc.
Try this:
$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(); It's better to use built-in Codeigniter Query-builder:
$this->db->select('*'); $this->db->where([ 'status' => 1, 'country' => 5, 'product_price >' => 50, 'product_price <=' => 100, ]); $this->db->order_by('product_id', 'DESC'); $this->db->get('products'); $product = $this->db->result(); You can try this solution for your problem :
$query = $this->db->query('select * from products where status='1' AND country='5' AND product_price > "50" AND product_price <= "100" order by product_id desc'); $row_array = $query->result_array(); I Hop it will help you.
Try this
$this->db->from('products'); $this->db->where("status='1' AND country='5' AND product_price > '50' AND product_price <= '100'", null, false); $this->db->order_by("product_id", "desc"); $query = $this->db->get(); return $query->result_array(); Please try below code:
$this->db->select('products.*'); $this->db->from('products'); $sql="status='1' AND country='5' AND (product_price > '50' AND product_price <= '100')"; $this->db->where($sql, NULL, FALSE)->order_by("product_id", "DESC"); $products_query = $this->db->get(); $products_info_array = array(); $products_info_array = $products_query->result_array(); return $products_info_array; Can you "describe" type the table? If the field "product_id" is text (Example: VARCHAR), then it will never follow the order asc/desc..
Sorry My English.. Good work!
