$this->db->select_count()

Writes a “SELECT COUNT(1) as alias” portion for your query. You must provide an alias for the output field.

$this->db->select_count('your_alias');
$query = $this->db->get('members'); // Produces: SELECT COUNT(1) as your_alias FROM members