Delete cascade ?

Hello,
I have an article table and a comment table. I hope that the comments of the article also disappear, how to do?

Thank you in advance

PHP Code:

$data = array(
   'deleted' => 1
);

$this->db->where('article_id', $article_id);
$this->db->update('article', $data); 


i prefer the soft delete. After x-months you can delete the rows.

If you use foreign keys you only need to delete the article (on delete cascade)

http://www.mysqltutorial.org/mysql-foreign-key/


if not: delete first the comments then the article

PHP Code:

$this->db->where('article_id', $article_id);
$status = $this->db->delete('comments');
...
$this->db->where('article_id', $article_id);
$this->db->delete('article');
....