[RESOLVED] Loop each day from one start date to an end date

[Pulsorock]

Hello I'm looking to make a daily loop from an start date to an end date and execute some sql for each day. Something like:

$start_date = "2007-10-20";
$end_date = "2007-12-10";

$loop_date = $start_date;
while ($loop_date <= $end_date) {

echo $loop_date;
echo "<br>";

$loop_date++;
}

The problem with this code is that the variables are treated as text instead of date values. Because of this the output is something like:

2007-10-20
2007-10-21
2007-10-22
2007-10-23
2007-10-24
2007-10-25
2007-10-26
2007-10-27
2007-10-28
2007-10-29
2007-10-30
2007-10-31
2007-10-32
2007-10-33
[...]
2007-10-41
2007-10-42
2007-10-43
2007-10-44
2007-10-45

and so on... it will never end, because it will stay in an endless loop. I need a way to loop from a start day and an end day with the daily dates.

I search online, but couldn't find a solution that worked.

Any ideas?

Thanks!
G

[Beffic]

Maybe try putting in an else statement for the "while" so that if the day is "==" to the $end_date it will go back t the beginning.

Don't know if this will help at all but it's just a suggestion.

[bradgrafelman]

I don't know how efficient it would be, but you could use this instead to increment the date:

$loop_date = date('Y-m-d', strtotime($loop_date . '+1 day'));

[Pulsorock]

Hello,

I'm not sure how the else statement would work. I think the main problem that I have is that I need the while to treat the variables as date fields and adds one day on each loop. Otherwise it will only loop to 2007-10-20 through 2007-10-99 and then 2007-10-00 and there it goes the endless loop. But what I really need is that the while goes through actual dates. (ie: 2007-10-20, 2007-10-20, [...], 2007-10-31, 2007-11-01, 2007-11-02, [...]) and so on until the end_date value.

Hope this clarifies the problem...

Thanks

[Pulsorock]

bradgrafelman, your suggestion worked. Using that for the incremental value.

Thank you very much...