<?php
require_once("includes/config.php");
$pagename = "category";
$cat_id = $_GET['id'];

$zuk = mysql_query("SELECT * FROM kategoriler where id order by id");
while ($kuz = mysql_fetch_array($zuk)) {

$dondur = seo_cevir($kuz[kategori_name]);

if ($cat_id == $dondur){

$buldukid = $kuz[id];

}}

$kl = mysql_query("SELECT * FROM kategoriler where id=$buldukid");
$rw = mysql_fetch_array($kl);

require("includes/header.php");
?>
<h2><?=$rw[kategori_name];?> Kategorisindeki Filmler</h2>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
    <td valign="top" align="left" width="130"><b>Türü</b></td>
    <td valign="top" align="center" width="10"></td>
    <td valign="top" align="left" width="400"><b>Adı</b></td>
    <td valign="top" align="left" width="110"><b>Tarih</b></td>
    <td valign="top" align="left"><b>İndirilme</b></td>
</tr>
<?php
$s = $_GET['sayfa'];
if($s == "")
 $s = 0;
 else
  $s = ($s-1) * 10; 
$sq = mysql_query("SELECT * FROM icerik where kat_id=$buldukid order by id desc limit 0,10");
while ($rw = mysql_fetch_array($sq)) {

    $kat_id = $rw[kat_id];
    $icerik_id = $rw[id];

    $ppp = mysql_query("SELECT * FROM download where icerik_id=$icerik_id");
    $ckc = mysql_numrows($ppp);

    $kt = mysql_query("SELECT * FROM kategoriler where id=$kat_id");
    $rws = mysql_fetch_array($kt)


?>
<tr>
    <td valign="top" align="left"><?=$rws[kategori_name];?></td>
    <td> | </td>
    <td valign="top" align="left"><a href="<?=$siteurl?>/premium-<? echo seo_cevir(kucult($rw[icerik_title]));?>.html"><?=$rw[icerik_title];?></a></td>
    <td valign="top" align="left">
    <?
    $ektarih = $rw[tarih];
    $bollan = explode(" ",  $ektarih);
    $cozlan = $bollan[0];
    
    if ($bugunt==$cozlan) { echo "Today ".$bollan[1]; }else{ echo $bollan[0]; }
    ?></td>
    <td valign="top" align="center"><?=$ckc;?></td>
</tr>
<?}?>

</table>
<? require("includes/footer.php"); ?>