include('includes/inc_config.php');?>
if($_REQUEST['id']){
$SQL = "SELECT id, DATE_FORMAT(fecha,'%s') AS fecha,
titulo_es AS titulo, detalle_es AS detalle, intro_es AS intro,
imagen_gr AS imagen
, IF(categoria = 'N', 'Noticias', 'Capacitación') AS cat
, IF(categoria = 'N', 'noticias', 'capacitación') AS cat2,
categoria
FROM noticias
WHERE 1 AND id = %d;";
}else{
$SQL = "SELECT id, DATE_FORMAT(fecha,'%s') AS fecha,
titulo_es AS titulo, detalle_es AS detalle, intro_es AS intro,
imagen_gr AS imagen
, IF(categoria = 'N', 'Noticias', 'Capacitación') AS cat
, IF(categoria = 'N', 'noticias', 'capacitación') AS cat2,
categoria
FROM noticias
WHERE 1 AND borrado = 'N' AND estado = 'Y'
ORDER BY destacado
LIMIT 1;";
}
$id = $_REQUEST['id'];
settype($id,'integer');
$SQL = sprintf($SQL,'%d.%m.%Y',$id);
$db = new database();
$rs = $db->db_query($SQL);
$fn = $db->db_fetch_assoc($rs);
?>
Decode LS, soluciones lingüísticas, servicios de traducción de idiomas, correctores y traductores graduados.
$SQL = "SELECT id, DATE_FORMAT(fecha,'%d.%m.%Y') AS fecha,
titulo_es AS titulo
FROM noticias t1
WHERE 1 AND borrado = 'N' AND estado = 'Y' AND id <> ".$fn['id']."
ORDER BY t1.fecha DESC
LIMIT 0,5;";
$rs = $db->db_query($SQL);
$fo = $db->db_fetch_assoc($rs);
if($fo){?>
do{?>
|
}while($fo = $db->db_fetch_assoc($rs));?>
}
?>
$SQL = "SELECT id, DATE_FORMAT(fecha,'%d.%m.%Y') AS fecha,
titulo_es AS titulo
FROM noticias t1
WHERE 1 AND borrado = 'N' AND estado = 'Y' AND id <> ".$fn['id']."
ORDER BY t1.fecha DESC
LIMIT 4,5;";
$rs = $db->db_query($SQL);
$fo = $db->db_fetch_assoc($rs);
if($fo){?>