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("Nowe filmy");

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

         

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

      

              echo "<table border='0' width='100%' onmouseover=\"this.style.background='#FFFFFF'\" onmouseout=\"this.style.background='#F6F6F6'\" style=\"border: 0px solid #F1F1F1\" bgcolor=\"#F6F6F6\">



  <tr>



    <td width='75%'>



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



        <tr>



          <td width='100%'>



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



		  </td>



        </tr>



        <tr>



          <td width='100%'>



		  <img src='images/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='images/ocena.gif'>&nbsp;<b>Ocena: </b>";



			 if ($wyn_rating) {



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



        } else {



        echo "Brak";



        }



echo "</tr>



        <tr>



          <td width='100%'>



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



		  </td>



        </tr>



        <tr>



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



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



		  echo "</td>



        </tr>



		   <tr>



          <td width='100%'>



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



		  if ($data['film_snippet']) {



        echo "".trimlink($data['film_snippet'],350)."<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='150' height='170' border='0'></a>



	</td>



  </tr>



</table>";

}

closeside();