<?php 
include('connect.php');
$angkatan = $_POST['angkatan'];
$perDosen = $_POST['perDosen'];

$dosen = array();
$query = "SELECT nama_dosen FROM dosen";
$hasil = mysql_query($query) or die (mysql_error());
while ($data = mysql_fetch_array($hasil))
{
	$dosen[] = $data['nama_dosen'];
}

$y = 0;
$x = 1;
$rs = mysql_query("select * from mahasiswa where angkatan = '$angkatan'");
while($mhs = mysql_fetch_array($rs)){
	$dsn = $dosen[$y];
	if($x % $perDosen == 0){
		$y++;
	}
	$query = "UPDATE mahasiswa SET dosen_krs = '$dsn' WHERE nim_akhir='".$mhs['nim_akhir']."'";
	$hasil = mysql_query($query)or die (mysql_error());
	$x++;
}
echo "<h2>Pembagian Dosen Pembimbing Berhasil</h2>";
?>