echo "<form name='searchform' method='post' action='".BASEDIR."searchfilm.php'><input type='text' name='stext' value='$stext' class='textbox' style='width:200px'>

<input type='submit' name='search' value='Szukaj filmu' class='button'><br>

</form><br>\n";



openside("<center><h2>NOWE FILMY</h2></center>");

   $result = dbquery("SELECT * FROM ".$db_prefix."film  ORDER BY film_id  DESC LIMIT 15");

         

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

      

               echo "<table border='0' width='100%'  style=\"border: 0px solid #F1F1F1\" ><hr>

<tr>

    <td width='75%'>

      <table border='0' width='100%'>

        <tr>

          <td width='100%'>

        <b>Tytuł: </b><a href='filmy.php?film_id=".$data['film_id']."'>".$data['film_subject']."</a>$new

        </td>

        </tr>

        <tr>

          <td width='100%'>

        <img src='komentarz.gif'>&nbsp;<b>Komentarzy: </b>";

          if ($count) {

        echo "".$count."";

        } else {

        echo "Brak";

        }

        echo "</td>

        </tr>

      <tr>";

      $wynik = dbquery("SELECT SUM(rating_vote) FROM ".$db_prefix."ratings WHERE rating_type='W' AND rating_item_id='".$data['film_id']."'");

$info = dbresult($wynik,0);

$num_rating = dbcount("(rating_vote)", "ratings", "rating_type='W' AND rating_item_id='".$data['film_id']."'");

$wyn_rating = ($num_rating ? $info / $num_rating : 0);

echo "<td><img src='ocena.gif'>&nbsp;<b>Ocena: </b>";

          if ($wyn_rating) {

        echo "".ceil($wyn_rating)."";

        } else {

        echo "Brak";

        }

echo "</tr>

        <tr>

          <td width='100%'>

        <img src='ogladano.gif'>&nbsp;<b>Ilość wyświetleń:</b> ".$data['film_reads']."

        </td>

        </tr>

        <tr>

          <td width='100%'><img src='data.gif'>&nbsp;";

        echo $locale['404'].showdate("shortdate", $data['film_datestamp'])."<br>\n";

        echo "</td>

        </tr>

         <tr>

          <td width='100%'>

        <img src='opis.gif'>&nbsp;<b>Opis: </b>"; 

        if ($data['film_snippet']) {

        echo "".trimlink($data['film_snippet'],460)."<br><br>";

        } else {

        echo "Brak<br><br>";

        }

        echo "</td>

      </table>

    </td>

    <td width='25%'>

   <a href='filmy.php?film_id=".$data['film_id']."'><img src='".$data['film_miniaturka']."' width='130' height='170' border='0'></a>

   </td>

  </tr>

</table>";

               



closeside();