• 05-10-2006, 14:02:55
    #10
    <?  
    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']; 
    //////////////////////// 
    ?>
  • 05-10-2006, 14:34:26
    #11
    Teşekkürler EjdeR şimdi istediğim gibi oldu +Rap