note 32487 added to function.time

Here's one way to generate all intermediate dates (in mySQL format) between any 2 dates. Get start and end dates from user input, you'd need to do the basic validations that : - start and end dates are valid dates - start date <= end date. //start date 2001-02-23 $sm=2; $sd=23; $sy=2001; //end date 2001-03-14 $em=3; $ed=14; $ey=2001; //utc of start and end dates $s=mktime(0,0,0,$sm, $sd, $sy); $e=mktime(0,0,0,$em, $ed, $ey); while($s<=$e){ print date('Y-m-d',$s)."< br >"; //display date in mySQL format $s=$s+86400; //increment date by 86400 seconds(1 day) } Hope this helps :) ---- Manual Page -- http://www.php.net/manual/en/function.time.php Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+32487 Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+32487&report=yes Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+32487&report=yes