Re: Generate automatic list of dates

----- Original Message ----- From: "Nitin" <nitinmehta@kappa.net.in> To: <php-general@lists.php.net>; "Tommi Virtanen" <mailinglist@gwad.net> Sent: Tuesday, December 02, 2003 3:12 PM Subject: Re: [PHP] Generate automatic list of dates > > ----- Original Message ----- > From: "Tommi Virtanen" <mailinglist@gwad.net> > To: <php-general@lists.php.net> > Sent: Tuesday, December 02, 2003 2:27 PM > Subject: [PHP] Generate automatic list of dates > > > > Hi! > > > > $first_date = 2003-12-01 > > $end_date = 2004-01-15 > > > > > > while ( $first_date <= $end_date) { > > > > $sql = "INSERT INTO time_table (id, date, person_id) VALUES > > (35,$first_date,0)"; > > $result = mysql_query($sql, $conn); > > > > [next date] WHAT CODE TO HERE???? > > $str = explode("-", "$first_date"); > $tst = mktime (0, 0, 0, $str[1], $str[2] +1, $str[0]); > $first_date = strftime ("%G-%m-%d", $tst); use $first_date = strftime ("%Y-%m-%d", $tst); instead... > > should do..... > > > > > } > > > > eg. > > > > first insert row is 35, 2003-12-01,0 > > next should be 35,2003-12-02,0 etc.... > > ... > > and last 35,2004-01-15,0 > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >