there are two tables
blogi +----+-----------+ | id | blog_cate | +----+-----------+ | 1 | database | | 2 | database | | 4 | razrabotka| +----+-----------+ blog_cate +----+------------------+---------------+ | id | blogi_cate_title | blogi_cate_url| +----+------------------+---------------+ | 1 | Базы данных | database | | 2 | PHP | php | | 3 | Разработка | razrabotka | +----+----------+-----------------+------
It is necessary to make a sample
so it was
Databases 2
Development 1
PHP 0
$this->db->select('blogi_cate.*, COUNT(blogi.blog_cate) as num'); $this->db->join('blogi', 'blogi.blog_cate = blogi_cate.blogi_cate_url'); $query = $this->db->get('blogi_cate');
Only one match does not work correctly.
Array ( [0] => stdClass Object ( [blogi_cate_id] => 3 [blogi_cate_title] => Базы данных [blogi_cate_url] => database [num] => 15 ) )