include 'connessione.php'; $pagina = 'interna'; if(isset($_GET['id_video_cat']) && $_GET['id_video_cat']!=''){ $id_video_cat = $_GET['id_video_cat']; }else{ $queryvcf = "SELECT * FROM video_cat WHERE visibile=1 ORDER BY ordine"; $resultvcf = mysql_query($queryvcf,$link); $rigavcf = mysql_fetch_array($resultvcf); $id_video_cat = $rigavcf['id_video_cat']; } $queryvct = "SELECT * FROM traduzioni WHERE tabella='video_cat' AND id=$id_video_cat AND lingua='$lingua'"; $resultvct = mysql_query($queryvct,$link); $rigavct = mysql_fetch_array($resultvct); $titolo = "comunicazione"; include 'header.php'; $titolo = $rigavct['titolo']; $queryvm= "SELECT * FROM video_cat WHERE visibile=1 ORDER BY ordine"; $resultvm = mysql_query($queryvm,$link); $tot_resvm = mysql_num_rows($resultvm); if(isset($_GET['id_video']) && $_GET['id_video']!=''){ $id_video = $_GET['id_video']; $queryn="SELECT * FROM video WHERE id_video=$id_video"; $resultn=mysql_query($queryn,$link); $rigan=mysql_fetch_array($resultn); $video = $rigan['video']; $querynt="SELECT * FROM traduzioni WHERE tabella='video' AND id=$id_video AND lingua='$lingua'"; $resultnt=mysql_query($querynt,$link); $rigant=mysql_fetch_array($resultnt); $titolovideo = $rigant['titolo']; $testovideo = $rigant['testo']; } $queryl= "SELECT * FROM video WHERE id_video_cat=$id_video_cat AND visibile=1 ORDER BY ordine"; $resultl= mysql_query($queryl,$link); $tot_resl = mysql_num_rows($resultl); $resultlev= mysql_query($queryl,$link); $tot_reslev = mysql_num_rows($resultlev); ?>