include("includes/conexion.php");
include("includes/funciones.php");
include("includes/idiomas.php");
if ($_GET["p"]=="")
{
$pagina=1;
}
else
{
$pagina = procesar_variable($_GET["p"], "numero");
}
if($_GET['sec'] != '')
{
$sql = " AND id_seccion=".procesar_variable($_GET['sec'], "numero");
}
else
{
$sql = "";
}
if($_GET['id'] != '')
{
$sql2 = " AND Id=".procesar_variable($_GET['id'], "numero");
}
else
{
$sql2 = "";
}
$fNombre = '';
if ($_COOKIE['lenguaje'] == 'en_GB') $fNombre = '_en_GB';
$seccion = mysql_query("SELECT nombre".$fNombre." AS nombref FROM secciones WHERE activo='si' AND visible='si' AND portal='SAM' AND id=".procesar_variable($_GET['sec'], "numero"), $link);
$datos_seccion = mysql_fetch_array($seccion);
$noticia = mysql_query("SELECT * FROM noticias WHERE activo='si' AND visible='si' AND portal='SAM' ".$sql." ".$sql2." ORDER BY fecha DESC, Id DESC LIMIT 1", $link);
if(mysql_num_rows($noticia) > 0)
{
$datos_noticia = mysql_fetch_array($noticia);
$noticias = mysql_query("SELECT * FROM noticias WHERE activo='si' AND visible='si' AND portal='SAM' AND Id<>".$datos_noticia['Id']." ".$sql." ORDER BY fecha DESC, Id DESC", $link);
$tamano_pagina = 5;
$primer_registro = ($pagina - 1) * $tamano_pagina + 1;
$ultimo_registro = $primer_registro + $tamano_pagina - 1;
$total_registros = mysql_num_rows($noticias);
$total_paginas = ceil($total_registros / $tamano_pagina);
$final = 0;
if ($ultimo_registro >= $total_registros)
{
$final = 1;
$ultimo_registro = $total_registros;
}
for($i=1; $i<$primer_registro; $i++)
{
$auxiliar = mysql_fetch_array($noticias);
}
}
?>
echo _("SAM, Sabores Auténticos de México"); ?>
|
|
include ("includes/funcionalidades.php"); ?>
|
|
include("includes/menu.php"); ?>
include('includes/col_izq.php'); ?>
|
|
|
|
© 2009 :: echo _("SABORES AUTÉNTICOS DE MEXICO"); ?> :: echo _("Todos los derechos reservados"); ?>
Website by: Viavox |
|