Delete cascade ?

Its all in the manual and much quicker to find then waiting for a reply in the forum

https://www.codeigniter.com/user_guide/d...mples.html

Thanks for all, I used an other solution 

PHP Code:

$this->db->select('*');
        $this->db->from('article');
        $this->db->join('blog_commentaires', 'blog_commentaires.id_article = article.id');
        $this->db->where('statut', "0");
        $this->db->order_by('blog_commentaires.date', 'DESC');
        
        $this->comments = $this->db->get()->result();

        return $this->comments;