Re: Dates between 2 dates

[laptop alias]

First you have either to build a calendar table containing the complete range of dates in which you're interested or build a table of integers (0-9) and join this onto the seed date as often as is required, e.g.:

SELECT ADDDATE('2010-01-30',INTERVAL i2.i*10+i1.i DAY) date 
  FROM ints i1
     , ints i2 
HAVING date -- or WHERE  ADDDATE('2010-01-30',INTERVAL i2.i*10+i1.i DAY)
       BETWEEN '2010-01-30' AND '2010-02-05' 
 ORDER 
    BY date;

A loop at the application level (e.g. with a bit of PHP) is another good way of doing this)