include 'connessione.php'; $pagina = 'home'; include 'header.php'; include 'data.php'; $querynw= "SELECT * FROM news WHERE visibile=1 ORDER BY data_news DESC LIMIT 0,2"; $resultnw= mysql_query($querynw,$link); $tot_resnw = mysql_num_rows($resultnw); $queryint="SELECT * FROM traduzioni WHERE tabella='intro' AND id=1 AND lingua='$lingua'"; $resultint=mysql_query($queryint,$link); $rigaint=mysql_fetch_array($resultint); $testointro = " "; if($rigaint['testo']!=''){ $testointro = $rigaint['testo']; } $queryvcf = "SELECT * FROM video_cat WHERE visibile=1 ORDER BY ordine"; $resultvcf = mysql_query($queryvcf,$link); $rigavcf = mysql_fetch_array($resultvcf); $queryvct = "SELECT * FROM traduzioni WHERE tabella='video_cat' AND id=".$rigavcf['id_video_cat']." AND lingua='$lingua'"; $resultvct = mysql_query($queryvct,$link); $rigavct = mysql_fetch_array($resultvct); $queryvm= "SELECT * FROM video_cat WHERE visibile=1 and id_video_cat<>".$rigavcf['id_video_cat']." ORDER BY ordine LIMIT 0,4"; $resultvm = mysql_query($queryvm,$link); $tot_resvm = mysql_num_rows($resultvm); $contacatv=0; $queryl2= "SELECT * FROM video WHERE id_video_cat=".$rigavcf['id_video_cat']." AND visibile=1 ORDER BY ordine LIMIT 1,3"; $resultl2= mysql_query($queryl2,$link); $tot_resl2 = mysql_num_rows($resultl2); $queryl= "SELECT * FROM video WHERE id_video_cat=".$rigavcf['id_video_cat']." AND visibile=1 ORDER BY ordine"; $resultvs= mysql_query($queryl,$link); $rigavs=mysql_fetch_array($resultvs); $queryvst="SELECT * FROM traduzioni WHERE tabella='video' AND id=".$rigavs['id_video']." AND lingua='$lingua'"; $resultvst=mysql_query($queryvst,$link); $rigavst=mysql_fetch_array($resultvst); //ID OFFERTA if(isset($_GET['ordine']) && $_GET['ordine']!=''){ $ordine = $_GET['ordine']; $queryoff = "SELECT * FROM offerte WHERE visibile=1 AND ordine>$ordine ORDER BY ordine"; $resultoff = mysql_query($queryoff,$link); $rigaoff =mysql_fetch_array($resultoff); $tot_resoff = mysql_num_rows($resultoff); $queryofft="SELECT * FROM traduzioni WHERE tabella='offerte' AND id=".$rigaoff['id_offerta']." AND lingua='$lingua'"; $resultofft=mysql_query($queryofft,$link); $rigaofft=mysql_fetch_array($resultofft); $tot_resofft = mysql_num_rows($resultofft); }else{ $queryoff = "SELECT * FROM offerte WHERE visibile=1 ORDER BY ordine"; $resultoff = mysql_query($queryoff,$link); $rigaoff =mysql_fetch_array($resultoff); $tot_resoff = mysql_num_rows($resultoff); $queryofft="SELECT * FROM traduzioni WHERE tabella='offerte' AND id=".$rigaoff['id_offerta']." AND lingua='$lingua'"; $resultofft=mysql_query($queryofft,$link); $rigaofft=mysql_fetch_array($resultofft); $tot_resofft = mysql_num_rows($resultofft); } ?>
=convertData($riganw['data_news'])?>
=$rigatnw['titolo']?>
=nl2br($rigatnw['sommario'])?> [...]