connection(); $ricnome=mysql_real_escape_string($ricnome); $riccode=mysql_real_escape_string($riccode); //se c' una ricerca: if (($ricnome!="") || ($riccode!="" )){ $cmd_ricerca.=" WHERE "; if ($ricnome){ $cmd_ricerca.=" titolo LIKE '$ricnome'"; } if ($riccode){ if ($ricnome) $cmd_ricerca.=" AND "; $cmd_ricerca.=" data LIKE '%$riccode%'"; } $cmd_ricerca.=" AND attivo = 1"; $cmd_ricerca.=" AND archivio = ".$archivio." ORDER BY id DESC "; } else{ if (isset($_GET["ricercatipo"])) { $cmd_ricerca.=" WHERE attivo = 1 AND archivio = ".$archivio." AND testo1 LIKE '%".mysql_real_escape_string($_GET["ricercatipo"])."%' ORDER BY id ASC"; }else { $cmd_ricerca.=" WHERE archivio = ".$archivio." AND attivo = 1 ORDER BY id DESC"; } } ?>

Norme Vigenti

Archivio

query($cmd_ricerca); $sql_news_list_2 = new mod_db(); $sql_news_list_rs_2 = $sql_news_list_2->query($no_limit); $tot_elementi = $sql_news_list_2->nums(); $tot_pagine = ceil($tot_elementi / $fine); ?> objects('', $sql_news_list_rs)){ $titolo = $news -> titolo; $descrizione1 = $news -> descrizione1; $descrizione2 = $news -> descrizione2; $descrizione3 = $news -> descrizione3; $testo1 = $news -> testo1; $testo2 = $news -> testo2; $testo3 = $news -> testo3; $data = $news -> data; $file1 = $news -> file1; $file2 = $news -> file2; $file3 = $news -> file3; $file4 = $news -> file4; $file5 = $news -> file5; $file6 = $news -> file6; $file7 = $news -> file7; $file8 = $news -> file8; $file9 = $news -> file9; $file10 = $news -> file10; $dfile1 = $news-> des_file1; $dfile2 = $news-> des_file2; $dfile3 = $news-> des_file3; $dfile4 = $news-> des_file4; $dfile5 = $news-> des_file5; $dfile6 = $news-> des_file6; $dfile7 = $news-> des_file7; $dfile8 = $news-> des_file8; $dfile9 = $news-> des_file9; $dfile10 = $news-> des_file10; $id = $news -> id; $updateDate = strtotime($news->updatedat); $updateDate = date("d/m/y", $updateDate); ?>