|
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();
// "SELECT C.*, U.RAGIONE AS FONTE FROM COMUNICATI C, UFFICI_STAMPA U WHERE U.ID = C.ID AND C.FLAG = 1 ORDER BY ID_COM DESC LIMIT 1"
$sql = "SELECT C.*, U.RAGIONE AS FONTE FROM COMUNICATI C, UFFICI_STAMPA U WHERE U.ID = C.ID AND C.FLAG = 1 AND (TESTO LIKE '%$nome%' OR LUOGO LIKE '%$nome%' OR TITOLO LIKE '%$nome%' OR EMITTENTE LIKE '%$nome%') ORDER BY ID_COM DESC";
$result = mysql_query($sql);
for ($counter=0;($counter<1000 and $data=mysql_fetch_array($result));$counter++){
if ($data["ALLEGATO"] != ""){
echo " |