while lus met break (Opgelost)

SELECT doss.main_id,kad.KAD_GETAL, kad.kad_let, kad.kad_cijf FROM main doss,aanvr a,KAD kad where a.aanvr_nr = doss.nr_aanvr and a.aanvr_jr = doss.jr_aanvr and a.AANVR_JR = kad.KAD_AANVJR and a.AANVR_NR = kad.KAD_AANVNR and doss.main_id in (65856,65870,65871,65889,65894)

SELECT doss.main_id,kad.KAD_GETAL, kad.kad_let, kad.kad_cijf FROM main doss,aanvr a,KAD kad WHERE a.aanvr_nr = doss.nr_aanvr AND a.aanvr_jr = doss.jr_aanvr AND a.AANVR_JR = kad.KAD_AANVJR AND a.AANVR_NR = kad.KAD_AANVNR AND doss.main_id IN (65856,65870,65871,65889,65894)

<?php 
$main_id_oud = '';
while( $row_lijst = sqlsrv_fetch_array( $stmt_lijst, SQLSRV_FETCH_ASSOC)){
	if($main_id_oud != $row_lijst['bv_main_id']){
		// PRINT ALLE INFO!!
	}else{
		// VUL VAR MET WAARDE!!
	}
	$main_id_oud = $row_lijst['bv_main_id'];
}
?>

<?php 
$main_id_oud = '';
while( $row_lijst = sqlsrv_fetch_array( $stmt_lijst, SQLSRV_FETCH_ASSOC)){
	if($main_id_oud != $row_lijst['bv_main_id']){
		// PRINT ALLE INFO!!
	}else{
		// VUL VAR MET WAARDE!!
	}
	$main_id_oud = $row_lijst['bv_main_id'];
}
?>