looping a csv file w/ update query

[austint01]

I have a loop which works, but it should only upload on mon - fri, not sat and sun!

I thought i covered this problem but obviously not. There is no update query error!.

When i display the data, if i look at the proceeding week and then the one after an so on...the data 'goes out of sync' Say certain record exist for monday, the next week they will appear on thurday, week after...tuesday!!!!

anyone know whats going on

	for ($w=0;$w<=$numwks;$w++) {
		if(date("D",$date)!=="Sat" && date("D",$date)!=="Sun"){
			foreach( $week as $day )
			{
			$day_array = explode(',',$day);
			$time += (60*60*24); // used to increment the days
			$period = 0;
				for($i=0;$i<5;$i++) {
					$formatted = date('Y-m-d', $time);
					$period++;
					$sql = "UPDATE booking SET
								classname = '" . $day_array[$i] . "',
								username = '" . $day_array[$i+5] . "'
							WHERE
								datebooked = '" . $formatted . "'
								AND roomname = '" . $roomname . "'
								AND period = '" . $period . "'";
							mysql_query($sql) or die ('ERROR: ' .mysql_error());
				}
			} 
		}
	}

thanks😃

[Ghostwalker]

I think your problem is this line:

if(date("D",$date)!=="Sat" && date("D",$date)!=="Sun")

Try this:

if(date("D",$date)!="Sat" && date("D",$date)!="Sun")

[austint01]

It works just the same...i think the problem lies elsewhere! If i explain what i'd like to happen..cud someone explain if my code is wrong

I'd like to loop an array (timetable for a week) then split into days, then days into 5 periods. Update the data from each period into the database. As the csv file is the timetable fro a week, I want it to copy it thru a whole year.

heres the code:

	$filename = $_POST['filename'];
	$week = file($filename);
	$year = $_POST['year'];
	$roomname = $_POST['roomname'];
	$time = strtotime('last monday', mktime(0,0,0,9,1,$year));
	$numwks = 52;

for ($w=0;$w<=$numwks;$w++) {
		if(date("D",$date)!="Sat" && date("D",$date)!="Sun"){
		foreach( $week as $day )
		{
		$day_array = explode(',',$day);
		$time += (60*60*24); // used to increment the days
		$period = 0;
			for($i=0;$i<5;$i++) {
				$formatted = date('Y-m-d', $time);
				$period++;
				$sql = "UPDATE booking SET
							classname = '" . $day_array[$i] . "',
							username = '" . $day_array[$i+5] . "'
						WHERE
							datebooked = '" . $formatted . "'
							AND roomname = '" . $roomname . "'
							AND period = '" . $period . "'";
						mysql_query($sql) or die ('ERROR: ' .mysql_error());
			}
		} 
	}
}

thanks 😃