|
if (isset($_POST['nome'])) {
$nome = $_POST['nome'];
} else {
$nome = "";
}
function data_da(&$date){ //FUNZIONE PER LA FORMATTAZIONE DELLE DATE
$date_tmp = explode("-",$date);
$date = $date_tmp[2] . "/" . $date_tmp[1] . "/" . $date_tmp[0];
return $date;
}
include "connect.inc";
$link_id = db_connect();
$sql = "(SELECT TIP, OGGETTO, DATA_AVV AS DATAUNICA, ID_AVV AS IDUNICO, ALLEGATO, FLAG AS FOTO FROM AVVISI WHERE OGGETTO LIKE '%$nome%' AND FLAG = 1) UNION ALL(SELECT TIP, OGGETTO, DATA_DEC AS DATAUNICA, ID_DEC AS IDUNICO, ALLEGATO, FLAG AS FOTO FROM DELIB_CONS WHERE OGGETTO LIKE '%$nome%' AND FLAG = 1) UNION ALL (SELECT TIP, OGGETTO, DATA_DEG AS DATAUNICA, ID_DEG AS IDUNICO, ALLEGATO, FLAG AS FOTO FROM DELIB_GIUNT WHERE OGGETTO LIKE '%$nome%' AND FLAG = 1) UNION ALL (SELECT TIP, TITOLO AS OGGETTO, DATA_INIZIO AS DATAUNICA, ID_COM AS IDUNICO, ALLEGATO, FOTO FROM COMUNICATI WHERE TITOLO LIKE '%$nome%' AND FLAG = 1) ORDER BY DATAUNICA DESC";
$result = mysql_query($sql);
for ($counter=0;($counter<1000 and $data=mysql_fetch_array($result));$counter++){
switch ($data["TIP"]){
case "1" :
$estensioneallegati = "avv";
break;
case "2" :
$estensioneallegati = "dec";
break;
case "3" :
$estensioneallegati = "deg";
break;
case "4" :
$estensioneallegati = "";
break;
}
if ($data["ALLEGATO"] != ""){
echo " |