All pastes #805514 Raw Edit

Something

public text v1 · immutable
·published 2007-12-04 13:02 UTC
rendered paste body
while($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()); 
};
}; 
};