";
$conn = pg_pconnect("dbname=sif user=mike");
function showcontenido($queryname) {
$rowcount = pg_numrows($queryname);
if ($rowcount > 0) {
$rownumber = 0;
echo "";
do {
$getcontenido = pg_fetch_row($queryname, $rownumber);
echo $getcontenido[2];
$rownumber++;
} while ($rownumber < $rowcount);
echo "";
}
}
if (!$docid) {
$docid = 287;
}
if ($docid) {
$querydocinfo = pg_exec($conn, "SELECT p.docid, p.titulo_$lang, l.lengua, p.descripcion_$lang, p.fechadecreacion, p.fechamod, p.lugar_$lang, p.editorial_$lang, p.conferencia_$lang, p.conveniocon, e.estatus_$lang, p.especial, t.tipo_$lang, p.kb, p.lengua FROM principal p, lenguas l, estatuses e, tipos t WHERE p.lengua=l.lenguaid AND t.tipoid=p.tipo AND e.estatusid=p.estatus AND p.docid='$docid'");
$getdocinfo = pg_fetch_row($querydocinfo, 0);
$querycontlang = pg_exec($conn, "SELECT lenguaid FROM contenido WHERE docid='$docid' AND lenguaid='$lenguaid'");
if (pg_numrows($querycontlang) == 0) {
$querycontlang2 = pg_exec($conn, "SELECT lenguaid FROM contenido WHERE docid='$docid' AND lenguaid='$getdocinfo[14]'");
if (pg_numrows($querycontlang2) == 0) {
$lenguaid = 1;
} else {
$lenguaid = $getdocinfo[14];
}
}
$querycontenido = pg_exec($conn, "SELECT * FROM contenido WHERE docid='$docid' AND lenguaid='$lenguaid' ORDER BY chunkid");
$descripcion = $getdocinfo[3];
$titulo = $getdocinfo[1];
$fechadecreacion = $getdocinfo[4];
$fechamod = $getdocinfo[5];
$tamano = $getdocinfo[13];
include("../header.php3");
include("institucion_mapa.inc");
?>
|
|
|
".$$label."\n \n";
}
$i++;
}
?>
|
|
|
|
FUNREDES : $label_seccion :";
if ($docid != "287") {
echo " $label_titulo :";
}
echo " $titulo ";
echo " $getdocinfo[1]";
echo "";
if (strlen($descripcion) != 0) {
echo "$label_campo_descripcion: $getdocinfo[3] ";
}
showcontenido($querycontenido);
?>
|
|