how do I loop through a series of dates 1

[jmeckley]

I have a start date and an end date I want to loop through each month between those dates and I can't figure out how to do it currently I am echoing my results to the screen to confirm I am getting the right data.

here is my code

while ($e->fetch())
{
	$start = strtotime($e->install_date);
	$today = strtotime(date('Y-m-d'));
	$oeid = $e->Original_Equipment_id;

	for ($d = $start; $d <= $today; strtotime($d.' + 1 month'))
	{
		echo 'equpipment id: '.$oeid.', date: '.date('Y-m', $d).'<br>';
	}
}

the problem is the results only ever return the same value. it does not seem to increament at all.
1, 2004-11
1, 2004-11
1, 2004-11
1, 2004-11
1, 2004-11

any ideas?

Jason Meckley
Web Application Developer
SSIC

 

[kenrbnsn]

There are a number of errors in your code. Here's some code that does what you want.

<?
    $start = strtotime('2004-11-1');
    $today = strtotime('today');

    for ($d = $start; $d <= $today; $d=strtotime(' + 1 month',$d))
    {
        echo 'date: ' . date('Y-m', $d).'<br>'."\n";
    }
?>

Explanation:
For today's date, use the word "today" with strtotime.
In your "for loop", you never increment $d. I increment it by telling strtotime to add 1 month to the current value of $d.

Ken