model queries preference

[eluser]Brad K Morse[/eluser]
Try this in the model

Code:

function getPosts($table, $id = 'id', $limit = 100) {

  $q = $this->db->select('*')->from($table)->order_by($id, 'desc')->limit($limit);
  
  if($q->num_rows() > 0)
    return $q->result();
  
  return false;
}

calling in controller:

Code:

$data['posts'] = $this->main_mod->getPosts('posts', 'id', 50);