
<? require_once("coneccion.php");


$muni=$_GET['mun'];


?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SECRETARÍA DE EDUCACIÓN Y CULTURA</title>
<style type="text/css">
<!--
a:link {
	color: #000000;
	text-decoration: none;
}
a:visited {
	color: #000000;
	text-decoration: none;
}
a:hover {
	color: #CC0000;
	text-decoration: underline;
}
a:active {
	color: #CC0000;
	text-decoration: none;
}
-->
</style></head>
<script language="JavaScript">
	function cambiar_color_over(celda){
		celda.style.backgroundColor="#66ff33"
	}
	function cambiar_color_out(celda){
		celda.style.backgroundColor="#dddddd"
	}
	
	function cambia_color(){
		celda = document.getElementById("celda" + document.fcolor.celda.value)
		celda.style.backgroundColor=document.fcolor.micolor.value
	}
	</script>
<style type="text/css">
#contenedor {
	border: thin none #f6f6f6;
	width: 760px;
	margin-top: 0px;
	margin-right: auto;
	margin-bottom: 0px;
	margin-left: auto;
}
#head {
	background-image: url(header.gif);
	height: 171px;
	width: 760px;
	font-family: "Trebuchet MS";
	font-size: 10pt;
}
#contenido {
	background-image: url(back_miembros.jpg);
	height: auto;
	width: 760px;
	background-repeat:     repeat-x;
	font-family: "Trebuchet MS";
	font-size: 10pt;
	background-color:#FFFFFF;
	border-right-width: 1px;
	border-left-width: 1px;
	border-right-style: solid;
	border-left-style: solid;
	border-right-color: #D3D3D3;
	border-left-color: #D3D3D3;
}
#parrafo {
	background-image: url(hojas.gif);
	height: auto;
	width: auto;
	background-repeat: no-repeat;
	PADDING-LEFT: 21px; FLOAT: left; 
	PADDING-top: 21px;
	
}
#cuadro {
	background-image: url(fondo1.jpg);
	height: 105;
	width: 219;
	
	PADDING-top: 1px;
	background-repeat: no-repeat;

}

#foot {
	background-image: url(footer.jpg);
	height: 50px;
	width: 760px;
	font-family: "Trebuchet MS";
	font-size: 10pt;
	background-repeat:   repeat-x;
	font-weight: bold;
	
}
body {
	text-align:center;
	background-image: url(back_body.jpg);
	background-repeat:   repeat-x;
}
.Estilo9 {font-size: 8pt; }
</style>


<body>
<div id="contenedor">
<div id="head"></div>
<div id="contenido"><table width="100%" border="0" cellspacing="0" cellpadding="5">
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div align="justify"><br />
      <br />
      <div id ="parrafo">
        <table width="100%" border="0" cellspacing="0" cellpadding="5">
          <tr>
            <td valign="top"><p><strong>SELECCIONE LA ESCUELA PARA VER MÁS INFORMACIÓN</strong></p>
            <table border="1" cellpadding="5" cellspacing="0" bordercolor="#CCCCCC">
<tr>
<td bgcolor="#CCCCCC">&nbsp;</td>
<td width="136" bgcolor="#CCCCCC"><span class="style11"><strong>NIVEL</strong></span></td>
<td width="65" bgcolor="#CCCCCC"><span class="style11"><strong>CLAVE</strong></span></td>
<td width="117" bgcolor="#CCCCCC"><span class="style11"><strong>NOMBRE</strong></span></td>
<td width="145" bgcolor="#CCCCCC"><span class="style11"><strong>DOMICILIO</strong></span></td>
<TD bgcolor="#CCCCCC"><span class="style11"><strong>LOCALIDAD</strong></span></TD>
<TD bgcolor="#CCCCCC"><span class="style11"><strong>MUNICIPIO</strong></span></TD>
<TD width="73" bgcolor="#CCCCCC"><span class="style11"><strong>TURNO</strong></span></TD>
<TD width="74" bgcolor="#CCCCCC"><span class="style11"><strong>FUNDACIÓN</strong></span></TD>
</tr>

<?
$sql = "SELECT * FROM snombre order by nivel,municipio";
$result = mysql_query($sql); 
$conta=1;
//echo $sql; 
if($result!='') 
while($row = mysql_fetch_row($result)){ ?>
	<tr onmouseover='this.style.background="#f4f4f4"' onmouseout='this.style.background="white"'  style="cursor:hand" style="text-transform:uppercase;" onclick="window.open('info.php?cct=<? echo $row[2]; ?>&muni=<? echo $muni; ?>','_self')">
    <td align="left"><span class="style11 Estilo9"><? echo $conta; ?></span></td>
    <td align="left"><span class="style11 Estilo9"><? echo $row[1]; ?></span></td>
    <td align="left"><span class="style11 Estilo9"><? echo $row[2]; ?></span></td>
    <td align="left"><span class="style11 Estilo9"><? echo $row[3]; ?></span></td>
    <td align="left"><span class="style11 Estilo9"><? echo $row[4]; ?></span></td>
    <td align="left"><span class="style11 Estilo9"><? echo $row[6]; ?></span></td>
    <td align="left"><span class="style11 Estilo9"><? echo $row[8]; ?></span></td>
    <td align="left"><span class="style11 Estilo9"><? echo $row[10]; ?></span></td>
    <td align="left">  <span class="style11 Estilo9">
    <?
	$anio=substr($row[11],0,4);
	$mesito=substr($row[11],4,2);
	$diita=substr($row[11],6,2);
	echo $diita . "-" .$mesito. "-".$anio;?>
	</span></td>    
  
	</tr>
	<?
	$conta=$conta+1;
	} ?>    
</table>
              <p>&nbsp;</p>              
              <p><a href="listado.php">REGRESAR A LISTADO DE MUNICIPIOS </a></p>
               </td>
            </tr>
        </table>
      </div> 
      </div></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td align="center">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>

</div>
<div id="foot"><br />
  SECRETARIA DE EDUCACIÓN Y CULTURA</div>

</div>

</body>
</html>
