Re: Generate automatic list of dates
| From: | Nitin | Date: | Tue, 02 Dec 2003 09:42:25 +0000 |
| Subject: | Re: Generate automatic list of dates | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-171550@lists.php.net to get a copy of this message | ||
----- 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);
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
>