Onderstaande leerlingen volgden het traject HAVO2, TL3, TL4, HAVO4 fetchRow(MDB2_FETCH_ORDERED)) { echo('

Leerling '.$row[0].'

'); echo('

HAVO 2

'); $cijfers = mdb2_query($db, "SELECT vak, AVG(cijfer) FROM ploegman WHERE ll_id = {$row[0]} AND klas = 'HAVO2' AND schooljaar = '{$row[1]}' GROUP BY vak, soort ORDER BY vak"); mdb2_res_table($cijfers); echo('

TL 3

'); $cijfers = mdb2_query($db, "SELECT vak, AVG(cijfer) FROM ploegman WHERE ll_id = {$row[0]} AND klas = 'TL3' AND schooljaar = '{$row[2]}' GROUP BY vak ORDER BY vak"); mdb2_res_table($cijfers); echo('

TL 4

'); $cijfers = mdb2_query($db, "SELECT vak, AVG(cijfer) FROM ploegman WHERE ll_id = {$row[0]} AND klas = 'TL4' AND schooljaar = '{$row[3]}' GROUP BY vak ORDER BY vak"); mdb2_res_table($cijfers); //echo($row[0]); } html_end(); ?>