CODEWITHSUNDEEP
codeignitercount
Kevin Brown
Kevin Brown

Reputation: 12650

Codeigniter: Count columns with value for user

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

Upvotes: 1

Views: 12605

Answers (1)

Aren
Aren

Reputation: 55946

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

Upvotes: 3

Related Questions