Selam arkadaslar dizi sitem php scriptli ve kategori sayfasında database'den cekerken dizileri eklenme sırasına göre kategoriye ekliyor. Ben son eklenenden basa doğru kategori sayfasında sıralamasını istiyorum bunun icin nerede değişiklik yapmam lazım. Tahmin edebileceğiniz gibi pek anlamıyorum bu işlerden ama bu kolay olsa gere
<? include("ayar.php");
$id=$_GET['id'];
$aai=mysql_query("SELECT * FROM kategoriler where kat_id='$id'");
$mee=mysql_fetch_array($aai);
$kategori=$mee['kat_baslik'];
$kategoriaciklama=$mee['kat_aciklama'];
$limit=120;
$sayfa = !empty($_GET["sayfa"]) ? intval($_GET["sayfa"]) : 1;
$baslangic = ($sayfa - 1 ) * $limit;
$sorgu=mysql_query("SELECT * FROM videolar where kat_id='$id' order by id desc LIMIT $baslangic,$limit ");
$sor=mysql_query("SELECT * FROM videolar where kat_id='$id' order by id desc LIMIT $baslangic,$limit ");
$so=mysql_query("SELECT * FROM videolar where kat_id='$id' order by id desc LIMIT $baslangic,$limit ");
?>
<body>
<a name="top" id="top"></a>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="index_files/limiter_.gif" alt="" width="932" height="12" /></td>
</tr>
<tr>
<td>
<div id="wrapper">
<div id="logo_search">
<div id="logo">
<a href="index.html"><img src="index_files/logo0000.gif" border="0"/></a>
</div>
<div id="oneri"></div>
<div id="search_form">
<form action="arama.php" method="get" id="search" onsubmit="return validateSearch('true');">
<input name="search" type="text" value="" class="search_keywords" id="inputString" onkeyup="lookup(this.value);" onblur="fill();" autocomplete="off" />
<input name="btn" value="Dizi Ara" type="submit" class="search_bttn" />
<div class="suggestionsBox" id="suggestions" style="display: none;">
<div class="suggestionList" id="autoSuggestionsList">
</div>
</div>
</form>
</div>
</div>
<div id="menu">
<div id="menu_links">
<ul>
<li><a href="index.html">Ana Sayfa</a></li>
<li><a href="rastgele.html">Rastgele Bölüm Aç</a></li>
<li><a href="iletisim.php">Iletisim</a></li>
</ul>
</div>
</div><br />
<table width="886" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="150" valign="top">
<div id="reg_box">
<center><img src="index_files/cap_genr.gif" alt="Tür" /></center>
<div id="list_cats">
<ul>
<?
function herma($deger) {
$turkce=array("þ","Þ","ý","(",")","'","ü","Ü","ö","Ö","ç","Ç"," ","/","*","?","þ","Þ","ý","ð","Ð","Ý","ö","Ö","Ç","ç","ü","Ü");
$duzgun=array("s","S","i","","","","u","U","o","O","c","C","-","-","-","","s","S","i","g","G","I","o","O","C","c","u","U");
$deger=str_replace($turkce,$duzgun,$deger);
$deger = preg_replace("@[^A-Za-z0-9\-_]+@i","",$deger);
return $deger;
}
include("ayar.php");
$sql=mysql_query("SELECT * FROM kategoriler order by kat_baslik");
while($yaz=mysql_fetch_array($sql)){?>
<?
$mie=herma($yaz['kat_baslik']);
?><li><a href="kategoriler-<? echo $yaz['kat_id'];?>-<? echo $mie;?>.html"><? echo $yaz['kat_baslik'];?></a></li>
<? }?>
</ul>
</div>
</div>
<br>
<div id="reg_box">
<center><b><font color="brown">ETÝKETLER</b></font></center>
<center><? include("cokaranan.php");?></center>
<div id="list_cats">
</div>
</div>
<br /><br>
</td>
<td width="738" valign="top">
<div id="browse_main">
<table width="100%" border="0" cellspacing="3" cellpadding="3">
<tr>
<td width="80%" valign="top"><h2><? echo $kategori;?></h2></td>
<td width="20%" valign="top"></td>
</tr>
<tr>
<td colspan="2" valign="top"><? echo $kategoriaciklama;?>
</td>
</tr>
<tr>
<td colspan="2" valign="top">
</td>
</tr>
</table>
<div id="browse_results">
<ul>
<?
include("ayar.php");
$limit=120;
$sayfa = !empty($_GET["sayfa"]) ? intval($_GET["sayfa"]) : 1;
$baslangic = ($sayfa - 1 ) * $limit;
$sorgu=mysql_query("SELECT * FROM videolar where kat_id='$id' LIMIT $baslangic,$limit ");
$kactane=mysql_num_rows($sorgu);
if($kactane==0){?>
<center><b><? echo $kategori;?></b> Ýçin Kayýtlý Bölüm Bulunamadý.</center><? }else{?>
<? while($ciz=mysql_fetch_array($sorgu)){?>
<?
$kat=$ciz['kat_id'];
$kati=mysql_query("SELECT * FROM kategoriler where kat_id='$kat'");
$kategori=mysql_fetch_array($kati);
$nill=herma($ciz['baslik']);
?>
<li class="new">
<a href="video-<? echo $ciz['id'];?>-<? echo $nill;?>.html"><img src="<? echo $ciz['resim'];?>" alt="<? echo $ciz['baslik'];?>" class="imag" width="116" height="87" /><br />
<? echo $ciz['baslik'];?></a>
</li><? }}?>
</ul>
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="33%"> <span class="pag"><? include("test.php");?></span></td>
<td width="33%" align="right">
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td><img src="index_files/limiter0.gif" alt="" width="932" height="12" /></td>
</tr>
</table>
<div id="footer">
<div align="center">
<? include("ayar.php");
echo $footer;?> </div></div></body>
</html> 
