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 | 
       
      |