|
Notícias
$campos_query = "*";
$final_query = "FROM tbl_noticias where id_categoria_noticia='5' and status = '1' order by id_noticia DESC ";
$pagina = $_GET["pagina"];
if($pagina == "") {
$pagina = "1";
}
$td = mysql_query("select numero from tbl_contagem");
$vai = mysql_fetch_array($td);
$maximo = $vai['numero'];
$inicio = $pagina - 1;
$inicio = $maximo * $inicio;
$strCount = "SELECT COUNT(*) AS 'num_registros' $final_query";
$query = mysql_query($strCount);
$row = mysql_fetch_array($query);
$total = $row["num_registros"];
if($total <= 0) {
echo "Nenhum registro encontrado.";
} else {
if(!isset($_GET["seed"]))
{
$seed = rand();
} else {
$seed = addslashes($_GET["seed"]);
}
$strQuery = "SELECT $campos_query $final_query LIMIT $inicio,$maximo";
$query = mysql_query($strQuery);
while($row = mysql_fetch_array($query)) {
echo " ".$row["data"]." ";
echo "".$row["descricao"]."";
}
$menos = $pagina - 1;
$mais = $pagina + 1;
$pgs = ceil($total / $maximo);
if($pgs > 1 ){
if($menos>0){
echo "Anterior";
}
for($i=1;$i <= $pgs;$i++) {
if($i != $pagina) {
echo " $i ";
}
else {
echo "".$i."";
}
}
if($mais <= $pgs) {
echo "Próximo";
}
}
}
?>
|
|