<?
include("ayar.inc.php");
if( isset( $_GET['lim'] ) )
$news_limit_start = $_GET['lim'];
else
$news_limit_start = 0;
$query="select tabloadi.id,isim,baslik,kategori,yazi_id,kategorismi from tabloadi,kategoriadi
where kategoriadi.id = ".$_GET['katid']." ORDER BY id DESC";
$query.=" LIMIT ".$news_limit_start.",1";
$sonuc= mysql_query($query);
$grbliste="<table width=\"650\" border=\"1\" cellpadding=\"5\" cellspacing=\"0\" bordercolor=\"#3B3B3B\" bgcolor=\"313131\">";
while($satir=mysql_fetch_array($sonuc))
{
$grbliste.=" <tr><td>". $satir['kategori']."</td></tr>
<tr><td>". $satir['isim']."</td></tr>";
}
$grbliste.="</table>";
echo $grbliste;
//sayfalama kismi
$limit_go = $news_limit_start + 1;
$limit_back = $news_limit_start - 1;
$Sqlc="select count(tabloadi.id)i from tabloadi,kategoriadi
where tabloadi.yazi_id=kategoriadi.id
and kategoriadi.id=".$_GET['katid'];
$Sqlcs.=" LIMIT ".$news_limit_start.",1";
$dSetc = mysql_query( $Sqlc );
$dRowc = mysql_fetch_row( $dSetc );
$getpar="&katid=".$_GET['katid'];
////////////////////////
?> PHP'de id ye göre sıralama
10
●5.448
- 05-10-2006, 14:02:55