"; include("../../conecta.php"); $k='0'; $resultado=pg_exec("SELECT a.id_docente,a.nombres,a.paterno,a.materno FROM docentes a, dct_asignaciones b where a.id_docente=b.id_docente and b.id_gestion='$ges' and b.id_periodo='$per' and id_programa='$idc' and b.estado_registro='A' GROUP BY 1,2,3,4 order by a.paterno ASC"); $fi=pg_numrows($resultado); for($cont=0;$cont<$fi;$cont++) { $idd=pg_result($resultado,$cont,0); $nom=pg_result($resultado,$cont,1); $pat=pg_result($resultado,$cont,2); $mat=pg_result($resultado,$cont,3); echo ""; echo ""; $k=$k+1; echo "

$k

"; echo ""; echo ""; $fot='reg'.$idd; echo "
"; echo "
$tra $nom $pat $mat
"; echo ""; echo ""; //-- MATERIAS echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo "
Grupo
"; echo "
"; echo "
Sigla
"; echo "
"; echo "
Nombre de la materia
"; echo "
"; echo "
Nivel
"; echo "
"; echo ""; include("../../conecta.php"); $carr_asig=pg_exec("select * from dct_asignaciones where id_docente='$idd' and id_gestion='$ges' and id_periodo='$per' and id_programa='$idc' and estado='1' and estado_registro='A' order by id_materia,id_grupo ASC"); $fil=pg_numrows($carr_asig); for($y=0;$y<$fil;$y++) { $idm=pg_result($carr_asig,$y,2); $idg=pg_result($carr_asig,$y,3); include("conexion.php"); $materi=pg_exec("select * from pln_materias where id_materia=$idm and tipo='S'"); $fi2=pg_numrows($materi); if($fi2!='') { for($x=0;$x<$fi2;$x++) { $sig=pg_result($materi,$x,1); $nma=pg_result($materi,$x,2); $niv=pg_result($materi,$x,9); } }else { $sig='';$nma='';$niv='';$idg=''; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
"; echo "
$idg
"; echo "
"; echo "
$sig
"; echo "
"; echo "
$nma
"; echo "
"; echo "
$niv
"; echo "
"; echo ""; } echo ""; ?>