Generate sequence of dates

[Steve Lawrence]

Greetings. I was perusing the Variables feature of MySQL and thought it might be the solution to a problem I am having, but no luck. What I would like to do is generate a result set containing the next 21 days, starting from today. I tried:

set @startDay=CURDATE();
set @endDay = DATE_ADD(CURDATE(),INTERVAL 21 DAY);
set @day = @startDay;
SELECT @day:=DATE_ADD(@day:,INTERVAL 1 DAY) AS Day from Employee where @day < @endDay;

but there is lots of things wrong with this:
1: you can't assign a variable and reference it in the same select.
2: you can't reference a variable in a where clause.

Can any of you point me in the right direction to accomplish this? I would rather do it in the DB query than do it in PHP, which is what I have to do now.