Codeigniter active record select, left join, count
- by sea_1987
Hi There, I have a form that shows results from a database query, these results can have many other assets ajoined to them and I wanting to find a way of showing how many assets each elemement has. For example my table is of areas of england an other table has where the users live I current have this code,
$this->db->select('*');
$this->db->from('places');
$this->db->join('users, places.place_id = user.place_id, left');
$this->db->get();
The issue I am having is getting the query to return the place name and the number of users living in that place, it is possible?
