writing a row for each day. mySQL

writing a row for each day. mySQL

i've a web form, the user input two dates (YYYY/MM/DD) representing a
interval and other informations about an activity on a day.
EXAMPLE: he select 2013/09/12 to 2013/10/02 activity: Swimming
in that case my table will look like:
date | activity
2013/09/12 | swimming
2013/09/13 | swimming
2013/09/14 | swimming
2013/09/15 | swimming
2013/09/16 | swimming
and so on....
can i do this without iterate trough days manually? i'm using php+mysqli
thanks