opentable("Žiurimiausi filmai");

 

$result = dbquery("SELECT * FROM ".filmai_filmai." ORDER BY filmai_per DESC LIMIT 0,4");

 

//zanro rodytmo kodo pradzia

if (dbrows($result) != 0) {

   while($data = dbarray($result)) {

 

   $kategorijo=""; $kkk = 0;

         while ($kkk != 9) {

            if ($data['filmai_kat'.$kkk] != 0) {

               $rresult = dbquery("SELECT * FROM ".filmai_filmai_kat." WHERE filmai_kat_id = '".$data['filmai_kat'.$kkk]."'");

               if (dbrows($rresult)) { 

                  $kdata = dbarray($rresult); 

                  $kategorijo .= " ".$kdata['filmai_kat_pav'].",";}

               }

            $kkk++;   

         }

         $kategorijos = substr($kategorijo, 0, -1); 

         //zanro pabaiga

 

         //kalbos kodo pradzia

         $img = "<img src='/infusions/filmai_panel/img/kalba/lt.png' />";

                                 $img1 = "<img src=/infusions/filmai_panel/img/kalba/ru.png alt=>";

                                 $img2 = "<img src=/infusions/filmai_panel/img/kalba/en.gif alt=>";

  if($data['filmai_kalba'] == 0){

  $filmai_kalba = "<b><font color=yellow>Lie</font><font color=green>tu</font><font color=red>vi&#371; k.</font></b> $img";

  }elseif($data['filmai_kalba'] == 1){

  $filmai_kalba = "<b><font color=#ff7a7a>Rus&#371; k.</font></b> $img1";

  }if($data['filmai_kalba'] == 2){

  $filmai_kalba = "<b><b><font color=#00a9ff>Angl&#371; k.</font></b> $img2";

  }if($data['filmai_kalba'] == 3){

  $filmai_kalba = "<b><font color=green>Lietuvi&#371; sub.</font></b> $img";

  } 

         //kalbos pabaiga

 

      echo "<table><tr><td>";

      echo"<a href='/filmai.php?filmas_id=".$data['filmai_id']."'><img src='".$data['filmai_img']."' width='100' height='153'/></a>";

      echo "</td><td><b><a href='/filmai.php?filmas_id=".$data['filmai_id']."'>".$data['filmai_pav']."</a></b><br/>";

      echo "<b>Re&#382;isierius</b>: ".$data['filmai_rezisierius']."<br />";

      echo "<b>&#302;garsinimas:</b>  $filmai_kalba<br>";

      echo "<b>Premjera</b>: ".$data['filmai_metai']."<br />";

      echo "<b>&#381;anras</b>: ".$kategorijos."<br />";

      echo "<b>Trukm&#279;</b>: ".$data['filmai_trukme']."<br />";

      echo "</td></tr></table>";

   }

 

} else {

   echo "N&#279;ra film&#371;";

}

 

closetable();