Show Dates Between Start and End Date

teamfox20

can someone show me when i select a start date, number of times and frequency to show all the dates that fall between the two.

Start Date 3 drop down boxes:
start_mo, start_day, start_yr

Number of Times
List
1,2,3,4,5,.....

Frequency Drop Down:
- Weekly +7
- 2 Times a Month +14
- 3 Times a Month +21
- Monthly +30

Example:
Start Date : 10/18/2007

Of Times: 4

Frequency: Weekly
RESULTS
First Visit(1): 10/18/2007
Next Visit(2): 10/25/2007
Next Visit(3): 11/01/2007
Next Visit(4): 11/08/2007

bradgrafelman

Something like this, perhaps?

$start_date = '2007-10-01';
$number = 5;
$frequency = 7; // # of days in between

// --------------------

$start_date_unix = strtotime($start_date);

echo 'First Visit(1): ' . date('m/d/Y', $start_date_unix) . '<br>';

for($i=2,$date=strtotime("$start_date +$frequency days"); $i<= $number; $date=strtotime("$start_date +" . ($frequency*$i) . " days"),$i++)
	echo "Next Visit($i): " . date('m/d/Y', $date) . '<br>';

teamfox20

that is perfect, Thank you!

Would you by any chance be able to show me how to insert that into mysql?

bradgrafelman

Well, how do you want it stored? You could store the start and end dates, a comma-separated-list of all dates, just the starting date and parameters, ... ?