ben sadece son 15 konu çıksın istiyorum. Gerekli kodları veriyorum
yardımcı olabilirseniz çok sevinirim
Kod: Tümünü seç
<?php require_once('../Connections/p7r.php'); ?>
<?php
mysql_select_db($database_p7r, $p7r);
$query_arsiv = "SELECT * FROM s7_icerik ORDER BY x DESC";
$arsiv = mysql_query($query_arsiv, $p7r) or die(mysql_error());
$row_arsiv = mysql_fetch_assoc($arsiv);
$totalRows_arsiv = mysql_num_rows($arsiv);
$startRow_catssss = $sayfa * $maxRows_catssss;
$maxRows_catssss = 10;
$pageNum_catssss = 0;
if (isset($_GET['pageNum_catssss'])) {
$pageNum_catssss = $_GET['pageNum_catssss'];
}
$startRow_catssss = $pageNum_catssss * $maxRows_catssss;
mysql_select_db($database_p7r, $p7r);
$query_catssss = "SELECT * FROM s7_cat ORDER BY area ASC";
$query_limit_catssss = sprintf("%s LIMIT %d, %d", $query_catssss, $startRow_catssss, $maxRows_catssss);
$catssss = mysql_query($query_limit_catssss, $p7r) or die(mysql_error());
$row_catssss = mysql_fetch_assoc($catssss);
if (isset($_GET['totalRows_catssss'])) {
$totalRows_catssss = $_GET['totalRows_catssss'];
} else {
$all_catssss = mysql_query($query_catssss);
$totalRows_catssss = mysql_num_rows($all_catssss);
}
$totalPages_catssss = ceil($totalRows_catssss/$maxRows_catssss)-1;
// *** Visit Counter ***
// FELIXONE 2002 - SB by Felice Di Stefano - www.felixone.it
$FX_digit = 5;
$FX_dpath = "FX_DataCounter";
$FX_fpath = "FX_DataCounter/counter.txt";
// Check if directory and file exists, if not create it.
if (!file_exists($FX_fpath)) {
if (!is_dir($FX_dpath)) {
mkdir($FX_dpath, 0700);
}
$FX_fso = fopen($FX_fpath,"w");
flock($FX_fso, 2);
fputs($FX_fso, 0);
flock($FX_fso, 3);
fclose($FX_fso);
}
// Read file and update it any time
$FX_fso = fopen($FX_fpath,"r+");
$FX_count = fgets($FX_fso, 4096);
//session_start();
//if (!isset($HTTP_SESSION_VARS["FX_DataCounter"])) {
fseek($FX_fso, 0);
flock($FX_fso, 2);
fputs($FX_fso, $FX_count+1);
flock($FX_fso, 3);
fclose($FX_fso);
$FX_count++;
// $FX_DataCounter = $FX_count;
// session_register("FX_DataCounter");
//}
// Add leadings
$FX_numlength = strlen((string) $FX_count);
if ($FX_numlength < $FX_digit) {
$FX_lead = (int) $FX_digit - $FX_numlength;
for ($i=0; $i<$FX_lead; $i++) {
$FX_count = "0" . $FX_count;
}
}
?>
<link href="ariza.css" rel="stylesheet" type="text/css">
<table width="225" border="0" cellpadding="1" cellspacing="0" bgcolor="#7a7a7a">
<tr>
<td><form name="form1" method="get" action="../ara/?">
<input name="x" type="text" id="x" value="Aradığınız Kelime" size="20">
<input name="Submit" type="submit" class="inpara"
value="Sorgula" src="../ariza/interpol.gif" align="middle" width="69" height="21" >
</form>
<b><span class="highlight">
<font color="#C60408" face="Trebuchet MS" size="2">Bölümler</font></span></b>
<?php do { ?>
<table width="100%" border="1" cellspacing="1" cellpadding="2" bordercolor="#626062" bgcolor="#898789" style="border-collapse: collapse" height="22">
<tr>
<td width="94%"><strong><a href="../kategori/?civciv=<?php echo $row_catssss['x']; ?>"><font color="#000000" face="Georgia, Times New Roman, Times, serif"><?php echo $row_catssss['area']; ?></font></a></strong> </td>
</tr>
</table>
<?php } while ($row_catssss = mysql_fetch_assoc($catssss)); ?></td>
</tr>
<tr>
<td class="highlight">
</td>
</tr>
<tr>
<td class="highlight" bordercolor="#626062" bgcolor="#8C868C">
<?php include("../ankt/index.php"); ?></td>
</tr>
<tr>
<td class="highlight">
<b><font color="#C60408" face="Trebuchet MS" size="2">Son Konular</font></b></td>
</tr>
<tr>
<td> <?php do { ?>
<table width="100%" border="1" cellspacing="1" cellpadding="2" bordercolor="#626062" style="border-collapse: collapse" bgcolor="#898789">
<tr>
<td width="94%" valign="top"><a href="../konu/?x=<?php echo $row_arsiv['x']; ?>"><font color="#003366" face="Georgia, Times New Roman, Times, serif"><?php echo $row_arsiv['title']; ?></font></a> </td>
</tr>
</table>
<?php } while ($row_arsiv = mysql_fetch_assoc($arsiv)); ?><?php include("linkler.php"); ?>
</td>
</tr>
</table>
<?php
mysql_free_result($arsiv);
mysql_free_result($catssss);
?>
