"; //datos de identificacion
echo "| ".$con[2]." | ";
echo "".$con[3]." | ";
echo "SONORA | ";
echo "".$con[8]." | "; //municipio
echo "".$con[9]." | "; //nombremun
echo "".$con[6]." | ";
echo "".$con[7]." | ";
echo "".$con[4]." | ";
echo "".$con[20]." | "; //depadmva
echo "".$con[22]." | ";
echo "".$con[14]." | "; //zonaescola
echo "".$con[16]." | "; //sector
echo " | "; //dirservreg
echo "".$con[26]." | "; //sostenimie
echo "".$con[24]." | "; //servicio
echo " | "; //unidadresp
echo " | "; //programa
echo " | "; //subprog
echo "2011 | "; //periodo
echo " | "; //motivo
echo " | "; //dispon
echo " | "; //inst_bib
echo " | "; //dep_inst
$i01=mysql_query("select * from caracteristicas where id=".$con[0]);
$i=mysql_fetch_array($i01);
echo "".$i[1]." | ";
echo "".$i[3]." | ";
echo "".$i[2]." | ";
echo "".$i[4]." | ";
echo "".$i[5]." | "; // asientos
echo "".$i[7]." | ";
echo "".$i[8]." | ";
echo "".$i[14]." | ";
echo "".$i[15]." | ";
echo "".$i[21]." | ";
echo "".$i[22]." | "; // domingos horario continuo
echo "".$i[9]." | ";
echo "".$i[10]." | ";
echo "".$i[11]." | ";
echo "".$i[12]." | ";
echo "".$i[16]." | ";
echo "".$i[17]." | ";
echo "".$i[18]." | ";
echo "".$i[19]." | ";
echo "".$i[23]." | ";
echo "".$i[24]." | ";
echo "".$i[25]." | ";
echo "".$i[26]." | "; // domingos horario discontinuo
echo "".$i[27]." | "; // dias trabajados
if($i[28]==0) echo "X | "; else echo " | "; // Aqui va la clasificacion
if($i[28]==1) echo "X | "; else echo " | ";
if($i[28]==2) echo "X | "; else echo " | ";
if($i[28]==3) echo "X | "; else echo " | ";
if($i[28]==2) echo "".$i[29]." | "; else echo " | ";
if($i[30]==0) echo "X | "; else echo " | "; // Aqui van los catalogos.
if($i[30]==1) echo "X | "; else echo " | ";
if($i[30]==2) echo "X | "; else echo " | ";
if($i[31]==0) echo "X | "; else echo " | "; // Aqui van los estanteria.
if($i[31]==1) echo "X | "; else echo " | ";
if($i[31]==2) echo "X | "; else echo " | ";
echo "".$i[32]." | ";
echo "".$i[33]." | ";
echo "".$i[34]." | ";
echo "".$i[35]." | ";
$ii01=mysql_query("select * from servicios where id=".$con[0]);
$ii=mysql_fetch_array($ii01);
if($ii[1]==1) echo "X | "; else echo " | ";
if($ii[1]==1) echo "".$ii[2]." | "; else echo "0 | ";
if($ii[3]==1) echo "X | "; else echo " | ";
if($ii[3]==1) echo "".$ii[4]." | "; else echo "0 | ";
if($ii[5]==1) echo "X | "; else echo " | ";
if($ii[5]==1) echo "".$ii[6]." | "; else echo "0 | ";
if($ii[7]==1) echo "X | "; else echo " | ";
if($ii[7]==1) echo "".$ii[8]." | "; else echo "0 | ";
if($ii[9]==1) echo "X | "; else echo " | ";
if($ii[9]==1) echo "".$ii[10]." | "; else echo "0 | ";
if($ii[11]==1) echo "X | "; else echo " | ";
if($ii[11]==1) echo "".$ii[12]." | "; else echo "0 | ";
if($ii[13]==1) echo "X | "; else echo " | ";
if($ii[13]==1) echo "".$ii[14]." | "; else echo "0 | ";
if($ii[15]==1) echo "X | "; else echo " | ";
if($ii[15]==1) echo "".$ii[16]." | "; else echo "0 | ";
if($ii[17]==1) echo "X | "; else echo " | ";
if($ii[17]==1) echo "".$ii[18]." | "; else echo "0 | ";
if($ii[19]==1) echo "X | "; else echo " | ";
if($ii[19]==1) echo "".$ii[20]." | "; else echo "0 | ";
if($ii[21]==1) echo "X | "; else echo " | ";
if($ii[21]==1) echo "".$ii[22]." | "; else echo "0 | ";
if($ii[23]==1) echo "X | "; else echo " | ";
if($ii[23]==1) echo "".$ii[24]." | "; else echo "0 | ";
if($ii[25]==1) echo "X | "; else echo " | ";
if($ii[25]==1) echo "".$ii[26]." | "; else echo "0 | ";
if($ii[27]==1) echo "X | "; else echo " | ";
if($ii[27]==1) echo "".$ii[28]." | "; else echo "0 | ";
if($ii[29]==1) echo "X | "; else echo " | ";
if($ii[29]==1) echo "".$ii[30]." | "; else echo "0 | ";
if($ii[31]==1) echo "X | "; else echo " | ";
if($ii[31]==1) echo "".$ii[32]." | "; else echo "0 | ";
if($ii[33]==1) echo "X | "; else echo " | ";
if($ii[33]==1) echo "".$ii[34]." | "; else echo "0 | ";
if($ii[35]==1) echo "X | "; else echo " | ";
if($ii[35]==1) echo "".$ii[36]." | "; else echo "0 | ";
if($ii[37]==1) echo "X | "; else echo " | ";
if($ii[37]==1) echo "".$ii[38]." | "; else echo "0 | ";
if($ii[37]==1) echo "".$ii[39]." | "; else echo " | ";
$iv01=mysql_query("select * from colecciones where id=".$con[0]);
$iv=mysql_fetch_array($iv01);
if($iv[1]==1) echo "X | "; else echo " | "; //de consulta
if($iv[1]==0) echo "X | "; else echo " | ";
if($iv[2]==1) echo "X | "; else echo " | "; //especiales
if($iv[2]==0) echo "X | "; else echo " | ";
echo "".$iv[3]." | "; //colecciones
echo "".$iv[4]." | "; //volumenes
echo "".$iv[5]." | "; //escriba (temas)
echo " | ";
echo " | ";
echo " | ";
if($iv[6]==1) echo "X | "; else echo " | "; //generales
if($iv[6]==0) echo "X | "; else echo " | ";
if($iv[7]==1) echo "X | "; else echo " | "; //hemerograficas
if($iv[7]==0) echo "X | "; else echo " | ";
if($iv[8]==1) echo "X | "; else echo " | "; //audivisuales
if($iv[8]==0) echo "X | "; else echo " | ";
if($iv[9]==1) echo "X | "; else echo " | "; //electronicas
if($iv[9]==0) echo "X | "; else echo " | ";
$v01=mysql_query("select * from acervo whereid=".$con[0]);
$v=mysql_fetch_array($v01);
echo "".$v[1]." | ";
echo "".$v[4]." | ";
echo "".$v[7]." | ";
echo "".$v[10]." | ";
echo "".$v[2]." | "; //5
echo "".$v[5]." | ";
echo "".$v[8]." | ";
echo "".$v[11]." | ";
echo "".$v[3]." | "; //7
echo "".$v[6]." | ";
echo "".$v[9]." | ";
echo "".$v[12]." | "; //12
echo "".$v[13]." | ";
echo "".$v[16]." | ";
echo "".$v[19]." | ";
echo "".$v[22]." | ";
echo "".$v[14]." | ";
echo "".$v[17]." | ";
echo "".$v[20]." | ";
echo "".$v[23]." | ";
echo "".$v[15]." | ";
echo "".$v[18]." | ";
echo "".$v[21]." | ";
echo "".$v[24]." | ";
echo "".$v[25]." | "; // vamos bien
echo "".$v[28]." | ";
echo "".$v[31]." | ";
echo "".$v[34]." | ";
echo "".$v[26]." | ";
echo "".$v[29]." | ";
echo "".$v[32]." | ";
echo "".$v[35]." | ";
echo "".$v[27]." | ";
echo "".$v[30]." | ";
echo "".$v[33]." | ";
echo "".$v[36]." | ";
echo "".$v[37]." | "; // vamos bien
echo "".$v[40]." | ";
echo "".$v[43]." | ";
echo "".$v[38]." | ";
echo "".$v[41]." | ";
echo "".$v[44]." | ";
echo "".$v[39]." | ";
echo "".$v[42]." | ";
echo "".$v[45]." | ";
echo "".$v[53]." | "; //la sumatoria
if($v[46]==2) echo "X | "; else echo " | ";
if($v[46]==1) echo "X | "; else echo " | ";
if($v[46]==0) echo "X | "; else echo " | ";
if($v[47]==2) echo "X | "; else echo " | ";
if($v[47]==1) echo "X | "; else echo " | ";
if($v[47]==0) echo "X | "; else echo " | ";
if($v[48]==2) echo "X | "; else echo " | ";
if($v[48]==1) echo "X | "; else echo " | ";
if($v[48]==0) echo "X | "; else echo " | ";
if($v[49]==2) echo "X | "; else echo " | ";
if($v[49]==1) echo "X | "; else echo " | ";
if($v[49]==0) echo "X | "; else echo " | ";
if($v[50]==2) echo "X | "; else echo " | ";
if($v[50]==1) echo "X | "; else echo " | ";
if($v[50]==0) echo "X | "; else echo " | ";
if($v[51]==2) echo "X | "; else echo " | ";
if($v[51]==1) echo "X | "; else echo " | ";
if($v[51]==0) echo "X | "; else echo " | ";
if($v[52]==2) echo "X | "; else echo " | ";
if($v[52]==1) echo "X | "; else echo " | ";
if($v[52]==0) echo "X | "; else echo " | ";
$vi01=mysql_query("select * from personal where id=".$con[0]);
$vi=mysql_fetch_array($vi01);
echo "".$vi[1]." | "; //director
echo "".$vi[4]." | ";
echo "".$vi[7]." | ";
echo "".$vi[10]." | ";
echo "".$vi[13]." | ";
echo "".$vi[16]." | ";
echo "".$vi[19]." | ";
echo "".$vi[22]." | "; //sumatoria de total personal 1
echo "".$vi[2]." | "; //otro director
echo "".$vi[5]." | ";
echo "".$vi[8]." | ";
echo "".$vi[11]." | ";
echo "".$vi[14]." | ";
echo "".$vi[17]." | ";
echo "".$vi[20]." | ";
echo "".$vi[23]." | "; //sumatoria de total personal 2
echo "".$vi[3]." | "; //sumatorias
echo "".$vi[6]." | ";
echo "".$vi[9]." | ";
echo "".$vi[12]." | ";
echo "".$vi[15]." | ";
echo "".$vi[18]." | ";
echo "".$vi[21]." | ";
echo "".$vi[24]." | "; //sumatoria de total personal 2
echo "".$vi[25]." | ";
$vii01=mysql_query("select * from recursos where id=".$con[0]);
$vii=mysql_fetch_array($vii01);
echo "".$vii[1]." | ";
echo "".$vii[4]." | ";
echo "".$vii[6]." | ";
echo "".$vii[8]." | ";
echo "".$vii[3]." | ";
echo "".$vii[2]." | ";
echo "".$vii[5]." | ";
echo "".$vii[7]." | ";
echo "".$vii[9]." | ";
echo "".$vii[10]." | ";
echo "".$vii[12]." | ";
echo "".$vii[14]." | ";
echo "".$vii[16]." | ";
echo "".$vii[18]." | ";
echo "".$vii[20]." | ";
echo "".$vii[22]." | ";
echo "".$vii[24]." | ";
echo "".$vii[26]." | ";
echo "".$vii[28]." | ";
echo "".$vii[11]." | ";
echo "".$vii[13]." | ";
echo "".$vii[15]." | ";
echo "".$vii[17]." | ";
echo "".$vii[19]." | ";
echo "".$vii[21]." | ";
echo "".$vii[23]." | ";
echo "".$vii[25]." | ";
echo "".$vii[27]." | ";
echo "".$vii[29]." | ";
echo "".$vii[71]." | ";
echo "".$vii[72]." | ";
echo "".$vii[73]." | ";
echo "".$vii[74]." | ";
echo "".$vii[75]." | ";
echo "".$vii[76]." | ";
echo "".$vii[77]." | ";
echo "".$vii[78]." | ";
echo "".$vii[79]." | ";
echo "".$vii[80]." | ";
if($vii[30]==1) echo "X | "; else echo " | ";
if($vii[30]==0) echo "X | "; else echo " | ";
if($vii[31]==1) echo "X | "; else echo " | ";
if($vii[31]==0) echo "X | "; else echo " | ";
echo "".$vii[32]." | ";
echo "".$vii[33]." | ";
echo "".$vii[34]." | ";
echo "".$vii[35]." | ";
echo "".$vii[36]." | ";
echo "".$vii[37]." | "; // 5 1/4
echo "".$vii[38]." | ";
echo "".$vii[39]." | ";
echo "".$vii[40]." | "; // los procesadores
echo "".$vii[41]." | ";
echo "".$vii[42]." | ";
echo "".$vii[43]." | ";
echo "".$vii[44]." | ";
echo "".$vii[45]." | "; // especifique otros.
echo "".$vii[46]." | "; //las memorias
echo "".$vii[47]." | ";
echo "".$vii[48]." | ";
echo "".$vii[49]." | ";
echo "".$vii[50]." | "; //las impresoras
echo "".$vii[51]." | ";
echo "".$vii[52]." | ";
echo "".$vii[53]." | ";
echo "".$vii[54]." | ";
if($vii[55]!='') echo "".$vii[55]." | "; else echo " | ";
echo "".$vii[56]." | "; //sistemas operativos
echo "".$vii[57]." | ";
echo "".$vii[58]." | ";
echo "".$vii[59]." | ";
echo "".$vii[60]." | ";
if($vii[61]>0) echo "".$vii[61]." | "; else echo " | ";//automatizacion
if($vii[62]>0) echo "".$vii[62]." | "; else echo " | ";
if($vii[63]>0) echo "".$vii[63]." | "; else echo " | ";
if($vii[64]>0) echo "".$vii[64]." | "; else echo " | ";
if($vii[65]>0) echo "".$vii[65]." | "; else echo " | ";
if($vii[66]>0) echo "".$vii[66]." | "; else echo " | ";
if($vii[67]>0) echo "".$vii[67]." | "; else echo " | ";
if($vii[68]>0) echo "".$vii[68]." | "; else echo " | ";
if($vii[69]==1) echo "X | "; else echo " | ";
if($vii[70]==1) echo "X | "; else echo " | ";
echo "";
}
?>