rendered paste bodywhile($row = mysql_fetch_array( $result )) {
$ReminderArray = explode("|", $row['ReminderCalls']); //reminder calls is equal to something like 1|3|5|7|
$x = count($ReminderArray);
$i = 0;
while ($i < $x) {
if (isset($ReminderArray[$i])) {
//i get a notice saying day is undefined, but it should be day1 day3 day5 day7 etc
if ($_POST['day'.$ReminderArray[$i]] <> 1) {
$OneDayBefore = $_POST['day'.$ReminderArray[$i]]-1;
$DayBefore = $OneDayBefore."/".$_POST['month'.$ReminderArray[$i]]."/".$_POST['year'.$ReminderArray[$i]];
} else if ($_POST['month'.$ReminderArray[$i]] <> 1) {
switch ($_POST['month'.$ReminderArray[$i]) {
case 5:
case 7:
case 10:
case 12:
$OneDayBefore = 30;
break;
case 2:
$OneDayBefore = 28;
break;
default:
$OneDayBefore = 31;
break;
};
$OneMonthBefore = $_POST['month'.$ReminderArray[$i]]-1;
$DayBefore = $OneDayBefore."/".OneMonthBefore."/".$_POST['year'.$ReminderArray[$i]];
} else {
$OneYearBefore = $_POST['year'.$ReminderArray[$i]]-1;
$DayBefore = "31/12/".$OneYearBefore;
};
$i++;
mysql_query("INSERT INTO jobs (JobDueDate, JobCode, JobCourseCode, JobComplete)
VALUES ('".$DayBefore."', '1', '".$CourseCode."', 'FALSE')")
or die(mysql_error());
};
};
};