Count and Group By Query
Development and Programming
14 years ago
I’m trying to count all the entries for exp_clicks and group them by their entry id, but cant get it. any help would be appreciated.
I’ve tried, $this->EE->db->count_all(‘exp_clicks’, ‘entry_id’); $this->EE->db->count_all(‘exp_clicks’, $this->EE->db->group_by(‘entry_id’));
Here is the query statement
SELECT entry_id, COUNT(*) as “totalclicks” FROM exp_clicks GROUP BY entry_id
thanks
14 years ago
Try:
$this->EE->db->select("entry_id, COUNT(*) as totalclicks");
$this->EE->db->group_by('entry_id');
$this->EE->db->get('clicks');
14 years ago
One note: you don’t need to use ‘exp_’ in Active Record calls. EE will add those based on your current install.
14 years ago
perfect. thanks