get every month between 2 dates

Hi,

I have a simple problem I need help with.

I pass 2 dates to a script like this:

$date1 = "2004-01"
$date2 = "2004-07";

(the above is YYYY-MM)

I need to use each of these dates, and the months in between in a number of queries.

How can I get every month between these 2 dates

ie: what I am looking for is this
date:
2004-01
2004-02
2004-03
2004-04
2004-05
2004-06
2004-07

Thanks,
Martin

WHy not trim the last two (substr) and add one on. Then place it back onto the date string. Continue until the date = date2...

thanks.....why didn't I think of that 🙂

Here's the code:

$d1 = substr($date1,5,2);
$d2 = substr($date2,5,2);

while($d1 <= $d2){
	if(strlen($d1) == 1){$d1 = "0".$d1;}
	echo $d1."<br>";
	$d1 = $d1 + 1;
}

output:
01
02
03
04
05
06
07
08
09
10
11
12

when I pass the dates 2004-01 and 2004-12

Thanks,
Martin

Any idea for the best way to do this when the 2 dates are in different years? ie: get all months between 2003-01 and 2004-01