".$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); } ?>
0){ while ($riganw=mysql_fetch_array($resultnw)){ $querytnw="SELECT * FROM traduzioni WHERE tabella='news' AND id=".$riganw['id_news']." AND lingua='$lingua'"; $resulttnw=mysql_query($querytnw,$link); $rigatnw=mysql_fetch_array($resulttnw); ?>
Non ci sono news
0){ ?>
ULTIME OFFERTE



0){ print("Visualizza altri video

"); while ($rigal2=mysql_fetch_array($resultl2)){ $querylt="SELECT * FROM traduzioni WHERE tabella='video' AND id=".$rigal2['id_video']." AND lingua='$lingua'"; $resultlt=mysql_query($querylt,$link); $rigalt=mysql_fetch_array($resultlt); ?>  [...]