db_query("SELECT COUNT(*) AS n FROM noticias WHERE borrado = 'N' AND estado = 'Y' ".$ext.";");
$fp = $db->db_fetch_assoc($rs);
//----
$max_show = 7;
$desde = 0;
$actual = 0;
//---
$paginado = NULL;
$paginas = ceil($fp['n']/$max_show);
//---
if($_REQUEST['p']!=''){
$actual = $_REQUEST['p']-1;
$desde = $actual*$max_show;
}
//-----------
$paginado = array();
for($i=0;$i<$paginas;$i++){
if($i==$actual){
$paginado[] = 1+$i;
}else{
$paginado[] = ''.(1+$i).'';
}
}
$paginado = '
'.implode(' | ',$paginado).'
';
$SQL = "SELECT id, DATE_FORMAT(fecha,'%d/%m/%Y') AS fecha,
titulo_en AS titulo, intro_en AS intro, imagen_ch AS imagen,
IF(categoria = 'N', 'Noticias', 'Capacitación') AS cat
FROM noticias t1
WHERE 1 AND borrado = 'N' AND estado = 'Y'
".$ext."
ORDER BY t1.fecha DESC, destacado
LIMIT ".$desde.",".$max_show.";";
$rs = $db->db_query($SQL);
$fn = $db->db_fetch_assoc($rs);
if($fn){
do{?>
db_fetch_assoc($rs));
}
?>
Professional certifications:
HOME | OUR STUDIO | OUR TEAM | SERVICES | TECHNOLOGY | TRAINING | QUOTE | BLOG | CONTACT
Avenida Pueyrredón 974 (C1032ABW) | Ciudad Autónoma de Buenos Aires | República Argentina |
Avenida Pueyrredón 974 (C1032ABW) | Ciudad Autónoma de Buenos Aires | República Argentina |