How to add 7 days to mysql date?

[eluser]xwero[/eluser]
In CI form will this be something like

Code:

$this->db->set('date = DATE_ADD(NOW(), INTERVAL 7 DAY)');