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();