update activities set end DATE_ADD(end, INTERVAL 7 DAY) where activities.id = '%s'; An Error Was Encountered Error Number: 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATE_ADD(end, INTERVAL 7 DAY) where id = '1'' at line 1 update activities set end DATE_ADD(end, INTERVAL 7 DAY) where id = '1'