 |
Most Recent Publications |
 |
$tabla = "publicaciones";
$con = new DB_mysql;
$con->conectar("", "", "", "");
$con->consulta("SELECT TITLE,IDPUBLICACION,YEAR FROM ".$tabla." WHERE YEAR != 0 ORDER BY YEAR");
$rowsNum = $con->llenarListaVal()-1;
$limit = $rowsNum-3;
while ($rowsNum > $limit ){
$TITULO = $con->getVal($rowsNum,"TITLE");
$ID = $con->getVal($rowsNum,"IDPUBLICACION");
$FECHA = $con->getVal($rowsNum,"YEAR");
$rowsNum--;
?>
 |
echo $TITULO ?>
|
|
|
|
} ?>
|
|
|
|
 |
Present Events |
 |
$tabla = "eventos";
$con = new DB_mysql;
$con->conectar("", "", "", "");
$con->consulta("SELECT * FROM ".$tabla. " WHERE DESTACADO='S' AND OBSOLETO = 'N' ORDER BY FECHA DESC");
$rowsNum = $con->llenarListaVal();
for ($i=0;$i<$rowsNum;$i++){
$TITULO = $con->getVal($i,"TITULO");
$ID = $con->getVal($i,"IDEVENTO");
$FICHEROPDF = $con->getVal($i,"FICHEROPDF");
$FECHA = $con->getVal($i,"FECHA");
$FECHA = getFecha("l dS of F Y",$FECHA);
$FECHAFIN = $con->getVal($i,"FECHAFIN");
$FECHAFIN = getFecha("l dS of F Y",$FECHAFIN);
?>
 |
echo $TITULO ?> echo $FECHA; if ($FECHAFIN!="") echo " - ".$FECHAFIN; ?> if ($FICHEROPDF!=="") echo " Download PDF File: " ?> |
|
|
|
|
} ?>
|
|
|