//FETCH CUSTOMERS BY PERSONAL //
$query2 = mysql_query("SELECT klant_by FROM klanten ORDER BY klant_by");
$i=0;

while($row = mysql_fetch_array($query2)){
	$klant_by[] = $row['klant_by'];
}
$d == NULL;
if(!empty($klant_by)){
	foreach($klant_by as $k => $v){
		if($v !== $d){
			$query4 = mysql_query("SELECT personeel_voornaam FROM personeel WHERE personeel_id = '$v'");
			list($pers_naam)=mysql_fetch_array($query4);
			echo '"'.$pers_naam.'": { label: "'.$pers_naam.'", data: [';
			$query3 = mysql_query("SELECT klant_id, DATE_FORMAT(klant_regdatum, '%d-%m-%Y') AS date FROM klanten WHERE klant_by='$v' ORDER BY klant_by");
			while($row = mysql_fetch_array($query3)){
				echo '['.$row['date']. ',' .$row['klant_id'].'], ';
			}
			echo ']},';
		}
			$d = $v;
	}

}


"Hasan": { label: "Hasan", data: [[01-09-2011,76], [22-08-2011,48], [12-08-2011,47], [12-08-2011,46], [12-08-2011,45], [11-08-2011,44], [11-08-2011,43], [10-08-2011,42], [10-08-2011,41], [10-08-2011,40], [09-08-2011,39], [09-08-2011,38], [09-08-2011,37], [09-08-2011,36], [22-08-2011,49], [22-08-2011,50], [22-08-2011,51], [31-08-2011,72], [25-08-2011,63], [26-08-2011,69], [26-08-2011,70], [24-08-2011,60], [24-08-2011,59], [23-08-2011,58], [23-08-2011,57], [23-08-2011,56], [23-08-2011,55], [23-08-2011,54], [23-08-2011,53], [23-08-2011,52], [09-08-2011,35], [08-08-2011,34], [08-08-2011,33], [14-07-2011,16], [14-07-2011,15], [13-07-2011,14], [13-07-2011,13], [13-07-2011,12], [13-07-2011,11], [13-07-2011,10], [13-07-2011,9], [13-07-2011,8], [13-07-2011,7], [13-07-2011,6], [08-07-2011,5], [05-07-2011,3], [01-08-2011,17], [01-08-2011,18], [01-08-2011,19], [08-08-2011,32], [08-08-2011,31], [07-08-2011,30], [07-08-2011,29], [05-08-2011,28], [05-08-2011,27], [05-08-2011,26], [05-08-2011,25], [04-08-2011,24], [03-08-2011,23], [02-08-2011,22], [02-08-2011,21], [01-08-2011,20], [27-04-2011,1], ]},"Canan": { label: "Canan", data: [[25-08-2011,64], [25-08-2011,65], [25-08-2011,66], [31-08-2011,73], [01-09-2011,77], ]},"Zeynep": { label: "Zeynep", data: [[25-08-2011,67], [25-08-2011,68], [01-09-2011,74], [03-09-2011,78], ]},"Semra": { label: "Semra", data: [[27-08-2011,71], [01-09-2011,75], [03-09-2011,79], ]},