is there a front-end language that could be used to generate the endpoints of the date range?
for efficiency, you want this format --
WHERE fs.live_from >= '2011-02-01'
AND fs.live_from < '2011-03-01'
by using the first of the following month as the upper end, combined with a "less than" comparison, you don't have to figure out whether you have feb 29th or not ...
you could still construct those dates in the query itself, using several date calculations based on CURRENT_MONTH, but it's easier if you do it in the front-end app and just pass in the two dates