include "cabecalho.inc"; $menu = ""; $anocor = "2020"; $primeiro = ""; $passou = ""; $passou1 = ""; $passou2 = ""; $noticia = ""; if (isset($_GET["anocor"])) $anocor = $_GET["anocor"]; if (isset($_GET["menu"])) $menu = $_GET["menu"]; if (isset($_GET["noticia"])) $noticia = $_GET["noticia"]; require('conexao.php'); //and year( data_noticia ) = $anocor $query = "select descricao, data_noticia, id from noticia order by data_noticia desc "; //where data_inicio < current_date and data_fim > current_date and sts_ativo = 1 order by data_noticia desc $query1 = "select * from evento where data > current_date and sts_ativo = 1"; $query8 = "SELECT DISTINCT ( year( data_noticia ) ) as ano FROM `noticia` "; ?>
if ($result = mysqli_query($conexao, $query1)) {
while ($linha1 = mysqli_fetch_row($result)) {
?>
if ($passou2 != "1") {?>
EVENTOS $passou2 = 1; } ?> /*if ($linha1[7] != "") $site = " Site: $linha1[7]"; else $site = ""; $data = substr($linha1[4],8,2) . "/" . substr($linha1[4],5,2) . "/" . substr($linha1[4],0,4); $data_fim = substr($linha1[10],8,2) . "/" . substr($linha1[10],5,2) . "/" . substr($linha1[10],0,4);*/ ?> "; // Local: $linha1[2] Data:$data � $data_fim Contato: $linha1[6] $site"; ?> } }?> if ($result = mysqli_query($conexao, $query)) { while ($linha = mysqli_fetch_row($result)) { ?> if ($passou1 != "1" ) { //echo "Consulta de Noticias por Ano "; $passou1 = 1; } ?>
if ($linha[1] != "")
$data_noticia = substr($linha[1],8,2) . "/" . substr($linha[1],5,2) . "/" . substr($linha[1],0,4) . " } } ?> |
if ($menu != ""){
if ($noticia == "1")
{
$query5 = "select descricao_breve from noticia where id = $menu";
if ($result = mysqli_query($conexao, $query5)) {
$linha5 = mysqli_fetch_row($result) ;
}
echo " \"$linha5[0]\" "; } else { $query5 = "select * from evento where id = $menu "; if ($result = mysqli_query($conexao, $query5)) { $linha5 = mysqli_fetch_row($result) ; } if ($linha5[7] != "") $site = "Site: $linha5[7]"; else $site = ""; $data = substr($linha5[4],8,2) . "/" . substr($linha5[4],5,2) . "/" . substr($linha5[4],0,4); $data_fim = substr($linha5[9],8,2) . "/" . substr($linha5[9],5,2) . "/" . substr($linha5[9],0,4); echo "$linha5[1] "; echo " Local: $linha5[2] Data:$data à $data_fim Contato: $linha5[6] $site "; if ($linha5[3] != "") { ?> echo "Resumo } ?> } } ?> |