----- Original Message -----
From: "Nitin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Tommi Virtanen" <[EMAIL PROTECTED]>
Sent: Tuesday, December 02, 2003 3:12 PM
Subject: Re: [PHP] Generate automatic list of dates
>
> ----- 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);
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
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
