Re: [PHP] Generate automatic list of dates

2003-12-02 Thread Nitin
- 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 Mes

Re: [PHP] Generate automatic list of dates

2003-12-02 Thread Nitin
- 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 >

[PHP] Generate automatic list of dates

2003-12-02 Thread Tommi Virtanen
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 } eg. first insert row is 35, 2003-12-01,0 next