Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- public function all_infografis($index=0) {
- $this->output->cache(10);
- $date = new DateTime("now");
- $curr_date = $date->format('Y-m-d H:i:s');
- $this->db->select('miol_nuntium.title, miol_nuntium.slug, miol_nuntium.image, miol_nuntium.content, miol_nuntium.summary, miol_nuntium.status, miol_nuntium.datepublish, miol_nuntium.id as idsm, micom_compartments.id, micom_compartments.title as nama');
- $this->db->from('miol_nuntium');
- $this->db->join('micom_compartments', 'micom_compartments.id = miol_nuntium.compartment','left');
- //$this->db->where('is_headline', 1);
- $this->db->limit(20, $index);
- //$this->db->where('status', 'published');
- $this->db->order_by('miol_nuntium.datepublish','desc');
- $this->db->where('miol_nuntium.datepublish <=', $curr_date);
- $this->db->where('miol_nuntium.status', 'published');
- $this->db->where('miol_nuntium.compartment', '90');
- //$query = $this->db->get();
- $query = $this->db->query("SELECT COUNT(*) c FROM miol_nuntium");
- $data = $query->result_array();
- $this->db->reset_query(); // karena yg di atas sudah tidak digunakan kembali jd di hapus aja
- return $data;
- //----> disini error bg
- //return $query->result_array();
- }
Advertisement
Add Comment
Please, Sign In to add comment