All pastes #805515 Raw Edit

Something

public php 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()); };}; };