How Would I Go About Adding To The Current Date In Mysql?

[3raser]

I have several units (days, weeks, years) I'd like to add to the current date in MySQL. How would I go about doing this?

 

I tried:

 

ADDDATE(CURRENT_DATE(), INTERVAL {$length[0]} YEAR INTERVAL {$length[1]} MONTH INTERVAL {$length[2]} WEEK INTERVAL {$length[3]} DAY)

 

But doesn't work. Can you even add multiple intervals?

[Barand]

mysql> SELECT CURDATE() + INTERVAL 1 YEAR + INTERVAL 1 MONTH + INTERVAL 1 DAY as newdate;
+------------+
| newdate    |
+------------+
| 2013-12-06 |
+------------+