Getting Range of Dates

treeleaf20

I'd like to do a select on a range of dates. So for example I would like to select a week's worth of events. So for example I would like to select everything from 01/29/2006 to 02/05/2006 or something like that. My problem is for something like this how do I determine when the month changes and start over?

Thanks for the help in advance.

Sayian

Im not exactly sure how to do this, but my inner voice tells me your gonna need an array and www.php.net/date

gammaster

Hi!
This is not the solution just a hint.

$start = strtotime('2006-01-29 00:00:00');
$stop  = strtotime('2006-02-05 00:00:00');
$time  = $start;

// Loop weeks
while($time < $stop) {
   echo date('W', $time).'<br>';// Week number
   $time = strtotime("+1 week", $time);// Next week
   }

// Loop days
while($time < $stop) {
   echo strftime('%d', $time).'<br>';// Date
   $time = strtotime("+1 day", $time);// Next day
   }

treeleaf20

How would you populate the $start and $stop to get those dates, basically I want to get the date on the Sunday for the week and that would populate the $start variable and then I want to determine what the date is for the Saturday of that week. I would need to determine if the month and year changed in that week though.

I hope that helps things to be more clear.

Thanks for the continued help.

gammaster

Hi!
Her is some more stuff. With this and your own reading about date and time manipulation you should be able to figure out this.

$start = strtotime('2006-01-29 00:00:00');
$dayNumbOfWeek   = date('w', $start);

// 1 = monday
if($dayNumbOfWeek != 1)
   $mondayInStartWeek = strtotime("last Monday", $start);
else
   $mondayInStartWeek = $start;

$saturdayInStartWeek = strtotime("next Saturday", $mondayInStartWeek);
$sundayInStartWeek   = strtotime("+1 day", $saturdayInStartWeek);

$yearOnMonday = strftime('%Y', $mondayInStartWeek);
$yearOnSunday = strftime('%Y', $sundayInStartWeek);