Looping with dates

[amandab]

I am trying to develop a page that is a 12 month rolling forecast. So I want to draw the current date and then the date in 11 months. I have been able to do this loop within the same year, but when it rolls over to a new year it fails, I just get a blank screen and it freezes. I then want to grab the data for those months and if there isn't any make it so they can add data. I know this is confusing but any advice will be greatly appreciated. :eek:

[deltaforce229]

can you show us the code?

[amandab]

Below is the code for looping the months I am attempting to use. I have not working on the form yet, I don't know where to start. You might have a better way to do this. All I want is to make a twelve month rolling form. I would like to do this and have one submit button to update or insert records depending on if they are already in the database (mysql). So I want a form for all twelve months which will be twelve different records. Can this be done. Thank you in advance. I am stumped.

<?
$enddate = mktime(0, 0, 0, date("m")+4, date("d"), date("Y"));
$currentdate = date("Y-m");
$enddate = date("Y-m", $enddate); // the enddate

for ($currentdate = $currentdate; $currentdate <= $enddate; $currentdate++)
{
?>
<td>
<table>
<tr>
<td class="bodycopy"><? echo $currentdate; ?>
</td></tr>
</table>
</td>
<?
}
?>

[Weedpacket]

A lot of your problem is that you're trying to loop with a string like it was a number. Even if that worked, there's no reason to expect the string to behave like it was a date.

You know the date now and you know the date in four months' time. It looks like you want four tables - one per month?

for($months_from_now=0; $months_from_now<4; $months_from_now++)
{
    $date = strtotime('now +'.$months_from_now.' months');
    $display_date = date('Y-m', $date);
 ///  ...etc.
}