"" and (intval($_GET['id'])<>0)){ $id=$_GET['id'];} else {$id=19;}
if(isset($_GET['id']) && !is_numeric($_GET['id'])){$id=19;}
$codice_pag="PS01";
include("../connections/config.inc.php");
require_once("../elementi/include.php");
include("../elementi/funzioni.php");
//*************************************************** COMUNE **********************************
//anno congresso
$select_anno="select * from congressi where id='$id'";
$result_anno=mysql_query($select_anno,$db);
if($row_anno=mysql_fetch_array($result_anno)){
$id_anno=substr($row_anno['data_congresso'],0,4);
}
//elenco congressi
$select = "select congressi.id AS ID0,congressi.*,congressi2language.* from (congressi inner join congressi2language on congressi.id=congressi2language.idrif and idlang=1) order by data_congresso DESC";
$result = mysql_query($select,$db) or die(mysql_error());
$row = mysql_num_rows($result);
//prima lettura (x caso iniziale)
if ($row > 0){
$array = mysql_fetch_array($result);
$congresso=$array[nome];
$idlast=$array[ID0]; //id ultimo congresso (x vis. iscriz. online)
}
// ID congresso selezionato
if ($id=="") {
$id=$array[ID0];
}
//programma congresso (gruppo = 0)
$select_prog = "select congressi.id AS ID0,allegato.id as IDF,allegato.* from (((congressi inner join congressi2language on congressi.id=congressi2language.idrif and idlang=1) left join allegato2other on congressi.id=allegato2other.idtab and nometab='congressi' and gruppo=0) left join allegato on allegato2other.idfoto=allegato.id) where status='on' and congressi.id=$id LIMIT 0,1";
$result_prog = mysql_query($select_prog,$db) or die(mysql_error());
$row_prog = mysql_num_rows($result_prog);
if ($row_prog > 0){
$array_prog = mysql_fetch_array($result_prog);
}
//verifica esistenza ALBERGHI
$select_3 = "select alberghi.id from (alberghi inner join alberghi2language on alberghi.id=alberghi2language.idrif and idlang=1) where status='on' and alberghi.idparent=$id ";
$result_3 = mysql_query($select_3,$db) or die(mysql_error());
$row_3 = mysql_num_rows($result_3);
//verifica esistenza RASSEGNA
$select_4 = "select rassegna.id from (rassegna inner join rassegna2language on rassegna.id=rassegna2language.idrif and idlang=1) where status='on' and rassegna.idparent=$id ";
$result_4 = mysql_query($select_4,$db) or die(mysql_error());
$row_4 = mysql_num_rows($result_4);
//verifica esistenza COMUNICATI
$select_5 = "select comunicati.id from (comunicati inner join comunicati2language on comunicati.id=comunicati2language.idrif and idlang=1) where status='on' and comunicati.idparent=$id ";
$result_5 = mysql_query($select_5,$db) or die(mysql_error());
$row_5 = mysql_num_rows($result_5);
//verifica esistenza RELATORI
$select_6 = "select relatori.id from (relatori inner join relatori2language on relatori.id=relatori2language.idrif and idlang=1) where status='on' and relatori.idparent=$id ";
$result_6 = mysql_query($select_6,$db) or die(mysql_error());
$row_6 =mysql_num_rows($result_6);
//verifica esistenza ATTI DEL CONGRESSO
$select_7 = "select atticongresso.id from (atticongresso inner join atticongresso2language on atticongresso.id=atticongresso2language.idrif and idlang=1) where status='on' and atticongresso.idparent=$id ";
$result_7 = mysql_query($select_7,$db) or die(mysql_error());
$row_7 =mysql_num_rows($result_7);
//*******************************************************************************
//elenco partner ***************************
$select_ts = "select sponsor.id AS ID0,sponsor.*,sponsor2language.* from (sponsor inner join sponsor2language on sponsor.id=sponsor2language.idrif and idlang=1) where status='on' and idparent=$id and tipo='1' order by posiz";
$result_ts = mysql_query($select_ts,$db) or die(mysql_error());
$row_ts = mysql_num_rows($result_ts);
//elenco sostenitori ***************************
$select_sst = "select sponsor.id AS ID0,sponsor.*,sponsor2language.* from (sponsor inner join sponsor2language on sponsor.id=sponsor2language.idrif and idlang=1) where status='on' and idparent=$id and tipo='3' order by posiz";
$result_sst = mysql_query($select_sst,$db) or die(mysql_error());
$row_sst = mysql_num_rows($result_sst);
//elenco media partner ***************************
$select_mp = "select sponsor.id AS ID0,sponsor.*,sponsor2language.* from (sponsor inner join sponsor2language on sponsor.id=sponsor2language.idrif and idlang=1) where status='on' and idparent=$id and tipo='2' order by posiz";
$result_mp = mysql_query($select_mp,$db) or die(mysql_error());
$row_mp = mysql_num_rows($result_mp);
//elenco sponsor
$select_s = "select sponsor.id AS IDA,sponsor.*,sponsor2language.* from (sponsor inner join sponsor2language on sponsor.id=sponsor2language.idrif and idlang=1) where status='on' and idparent=$id and tipo='0' order by posiz";
$result_s = mysql_query($select_s,$db) or die(mysql_error());
$row_s = mysql_num_rows($result_s);
//elenco totale
$select_tot = "select sponsor.id AS IDC,sponsor.*,sponsor2language.*,foto.id as IDF,foto.* from (((sponsor inner join sponsor2language on sponsor.id=sponsor2language.idrif and idlang=1) left join foto2other on sponsor.id=foto2other.idtab and nometab='sponsor' and gruppo=0) left join foto on foto2other.idfoto=foto.id) where status='on' and idparent=$id order by tipo desc, posiz";
$result_tot = mysql_query($select_tot,$db) or die(mysql_error());
$row_tot = mysql_num_rows($result_tot);
?>
In questa sezione trovate l'elenco completo delle aziende che hanno deciso di collaborare e sostenere AIDP nell'anno in veste di Partner, Sponsor e Sponsor tecnico.
Per ciascuna Azienda trovate una breve descrizione, cliccando sul logo potrete collegarvi direttamente al loro sito.