All pastes #389351 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-03-10 18:12 UTC
rendered paste body
<?
		   $limit ="50";
		    $es= mysql_query("SELECT COUNT(id) AS mesaj_sayisi from kategoriler where kate like '%$a%'");
			$sira = mysql_fetch_array($es);
			$sayfa_sayisi = ceil($sira['mesaj_sayisi'] / $limit );
			if ( !$_GET['sayfa_no'] )
				$sayfa_no = 1;
			else
				$sayfa_no = $_GET['sayfa_no'];
			$alt_limit = ( $sayfa_no - 1 ) * $limit;
			


		  $li =  mysql_query("select makale_id,kate,makale_baslik from makaleler where kate like '%$a%' order by makale_id desc LIMIT $alt_limit,$limit ");
		  
		  while ( $yaz = mysql_fetch_array($li)) {
		
echo "<br>";

   echo "\n";

   echo "<img src='ok.gif'>  ";

   echo "<font size='2'><a href=makaleoku.php?makale_id=" . $kayit['makale_id'] . "&kategori=" . $kayit['kate'] .">" . $kayit['makale_baslik'] . "</a>";
		  }
		  
		
				$sayfa_yaz = 0;
				
				do
				{
					$sayfa_yaz++;
			
					if ( $sayfa_yaz == $sayfa_no )
						echo "<span class='unnamed2'>&nbsp;$sayfa_yaz </span>";
					else
						echo "<a href='?sayfa_$sayfa_yaz' class=\"unnamed2\" onmouseover='this.style.textDecoration=\"underline\";this.style.color=\"#990000\";' onmouseout='this.style.textDecoration=\"\";this.style.color=\"\";'> - $sayfa_yaz</a>   ";
			
				} while ( $sayfa_yaz < $sayfa_sayisi );
				
				?>