wrong dates in a schedule

[bigfella]

Hi Everyone,

I am using the following code (many thanks for the code folks BTW) to
generate 3 schedules in three tables one is a schedule with 7 day
intervals and two are daily schedules.

The two daily schedules seem to have out of sync dates at the start of
each schedule. The dates look as if they may be dates from the
preceding loop.

I am presuming that I need to reset something after the completion of
each loop but I am not sure what.

Many thanks

Darren

$now = time();
$day = $now + 7*24*60*60;
$cutoff = strtotime("+$months months");
while ($day <= $cutoff) {
$date = date('Y-m-d', $day);
$insert = "INSERT INTO daily_data SET subscr_id='$subscr_id',
date='$date'";
mysql_query($insert);
$day = $day + 7*24*60*60;
}
//then create a daily schedule in the excercise table
for($i=0;$i<=($sched);$i++)
mysql_query("INSERT INTO exercise_data SET subscr_id='$subscr_id',
date=date_add(now(),INTERVAL
LAST_INSERT_ID() DAY)");
//then create a daily schedule in the food and diet table
for($i=0;$i<=($sched);$i++)
mysql_query("INSERT INTO food_data SET subscr_id='$subscr_id',
date=date_add(now(),INTERVAL
LAST_INSERT_ID() DAY)");

[Gordon Burditt]

>I am using the following code (many thanks for the code folks BTW) to

generate 3 schedules in three tables one is a schedule with 7 day
intervals and two are daily schedules.

The two daily schedules seem to have out of sync dates at the start of
each schedule. The dates look as if they may be dates from the
preceding loop.
... date=dateadd(now(), INTERVAL LAST_INSERT_ID() DAY) ...

This is absolutely wierd. Shouldn't that be INTERVAL 7 DAY?
After you have a lot of people sign up, LAST_INSERT_ID() is going
to be a couple hundred or thousand, and certainly isn't what you
want. I also note that you never seem to use $i within the loops.
Perhaps that's what you want instead of LAST_INSERT_ID()?

You also never set $sched.
I am presuming that I need to reset something after the completion of
each loop but I am not sure what.

Many thanks

Darren

$now = time();
$day = $now + 7*24*60*60;
$cutoff = strtotime("+$months months");
while ($day <= $cutoff) {
$date = date('Y-m-d', $day);
$insert = "INSERT INTO daily_data SET subscr_id='$subscr_id',
date='$date'";
mysql_query($insert);
$day = $day + 7*24*60*60;
}
//then create a daily schedule in the excercise table
for($i=0;$i<=($sched);$i++)
mysql_query("INSERT INTO exercise_data SET subscr_id='$subscr_id',
date=date_add(now(),INTERVAL
LAST_INSERT_ID() DAY)");
//then create a daily schedule in the food and diet table
for($i=0;$i<=($sched);$i++)
mysql_query("INSERT INTO food_data SET subscr_id='$subscr_id',
date=date_add(now(),INTERVAL
LAST_INSERT_ID() DAY)");

Gordon L. Burditt