----- Original Message -----
From: "Tommi Virtanen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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);
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
