Codeigniter: Count columns with value for user

Question

How do I get a count of columns where('user_id', $id)...?

Answer 1

For Row Counts

$this->db->where('user_id', $id);
$this->db->from('myTable');
$cnt = $this->db->count_all_results();

For more details please see the CodeIgniter Documentation on ActiveRecord

Here

For Colunm Counts

$query = $this->db->where('user_id', $id)->get('myTable');
$cnt = $query->num_fields();

For more details please see the CodeIgniter Documentation on Database Query Results

Here