week, 1, 0), week, dag, lesuur EOQ ); $select = ''; $join = ''; $count = 0; $th = ''; $th2 = ''; $per1_select = NULL; $per1_count = 0; $per2_select = NULL; $per2_count = 0; $per3_select = NULL; $per3_count = 0; while ($row = mysql_fetch_array($result2)) { mysql_query_safe("INSERT IGNORE INTO cijfers (notitie_id, ppl_id) SELECT {$row[0]}, ppl_id FROM ppl JOIN ppl2grp USING (ppl_id) JOIN grp2vak USING (grp_id) WHERE grp2vak_id = '$grp2vak_id'"); $select .= ", l$count.cijfer {$row[1]}"; $join .=<<123'."\n"; $nid[$count] = $row[0]; $count++; } mysql_data_seek($result2, 0); if ($per1_select) { $select .= ", ROUND(( $per1_select )/$per1_count, 1) per1"; } if ($per2_select) { $select .= ", ROUND(( $per2_select )/$per2_count, 1) per2"; } if ($per3_select) { $select .= ", ROUND(( $per3_select )/$per3_count, 1) per3"; } $addselect = ''; if ($per1_select) { $add = 2; $addselect = ", per1 rap1"; if ($per2_select) { $add = 4; $addselect .= ", ROUND((per1 + per2)/2, 1) rap2"; if ($per3_select) { $add = 6; $addselect .= ", ROUND((per1 + per2 + per3)/3, 0) rap3"; } } } $result = mysql_query_safe(<<

'.mysql_field_name($result, $i)); }?>

	periode:
		'.$row[$i]); if ($row[$i]) { $sum[$i-3] += $row[$i]; $aantal[$i-3] += 1; } } } ?>
	gemiddeld	= 1) printf("%.2F", round($sum[$i]/$aantal[$i], 2)); ?>