[18-Apr-2016 21:04:37 Europe/Istanbul] PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/username/public_html/pkategori.php on line 192
sayfada hata vermiyor fakat error_log dosyası bu hatayla doluyor nekadar araştırdıysam bu sorunu çözemedim
192. satır burası
<?
}else{
while($rsDisplay = mysql_fetch_array($qrDisplay)) {
?>
php kodumda bu
<?
$adjacents = 6;
$query = "SELECT COUNT(kategori) as kategori FROM coklu_kategori where kategori='$id'";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[kategori];
$targetpage = "/$kat_k/$adi_seo";
$limit = GetName("select * from ebu_sayfalar","kategori");
$toplam = ceil($total_pages / $limit) ;
if($sayfa)
$start = ($sayfa - 1) * $limit;
else
$start = 0;
$sql = "select * from coklu_kategori where kategori='$id' order by id desc limit $start, $limit";
$qrDisplay = mysql_query($sql);
if ($sayfa == 0) $sayfa = 1;
$prev = $sayfa - 1;
$next = $sayfa + 1;
$lastpage = ceil($total_pages/$limit);
$lpm1 = $lastpage - 1;
$pagination = "";
if($lastpage > 1)
{
$pagination .= "";
if ($sayfa > 1)
$pagination.= "<a class=\"prev\" href=\"$targetpage/$prev/\"><span>geri</span></a></li>
";
else
$pagination.= "<a class=\"prev\" href=\"$targetpage/$prev/\"><span>geri</span></a></li>
";
if ($lastpage < 7 + ($adjacents * 2))
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $sayfa)
$pagination.= "<li><span class=\"item-active\">$counter</span></li>
";
else
$pagination.= "<li><a href=\"$targetpage/$counter/\"><span>$counter</span></a></li>
";
}
}
elseif($lastpage > 5 + ($adjacents * 2))
{
if($sayfa < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $sayfa)
$pagination.= "<li><span class=\"item-active\">$counter</span></li>
";
else
$pagination.= "<li><a href=\"$targetpage/$counter/\"><span>$counter</span></a></li>
";
}
$pagination.= "<li><a href=\"$targetpage/$counter/\"><span>...</span></a></li>
";
$pagination.= "<li><a href=\"$targetpage/$lpm1/\"><span>$lpm1</span></a></li>
";
$pagination.= "<li><a href=\"$targetpage/$lastpage/\"><span>$lastpage</span></a></li>
";
}
elseif($lastpage - ($adjacents * 2) > $sayfa && $sayfa > ($adjacents * 2))
{
$pagination.= "<li><a href=\"$targetpage/1/\"><span>1</span></a></li>
";
$pagination.= "<li><a href=\"$targetpage/2/\"><span>2</span></a></li>
";
$pagination.= "";
for ($counter = $sayfa - $adjacents; $counter <= $sayfa + $adjacents; $counter++)
{
if ($counter == $sayfa)
$pagination.= "<li><span class=\"item-active\">$counter</span></li>
";
else
$pagination.= "<li><a href=\"$targetpage/$counter/\"><span>$counter</span></a></li>
";
}
$pagination.= "<li><a href=\"$targetpage/$counter/\"><span>...</span></a></li>
";
$pagination.= "<li><a href=\"$targetpage/$lpm1/\"><span>$lpm1</span></a></li>
";
$pagination.= "<li><a href=\"$targetpage/$lastpage/\"><span>$lastpage</span></a></li>
";
}
else
{
$pagination.= "<li><a href=\"$targetpage/1/\"><span>1</span></a></li>
";
$pagination.= "<li><a href=\"$targetpage/2/\"><span>2</span></a></li>
";
for ($counter = $lastpage - (3 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $sayfa)
$pagination.= "<li><span class=\"item-active\">$counter</span></li>
";
else
$pagination.= "<li><a href=\"$targetpage/$counter/\">$counter</a></li>
";
}
}
}
if ($sayfa < $counter - 1)
$pagination.= "<li><a class=\"next\" href=\"$targetpage/$next/\"><span>İleri</span></a></li>
";
else
$pagination.= "
";
$pagination.= "";
}
?>
<?
if (kontrol("select * from coklu_kategori where id >1") == 0) {
?>
video yok
<?
}else{
while($rsDisplay = mysql_fetch_array($qrDisplay)) {
?>
<?$videobul = "Select * from videolar where id = '$rsDisplay[video]'";
$qrPagesx = mysql_query($videobul);
$videobulx = mysql_fetch_array($qrPagesx);?>
<?$hitbul = "Select * from izlenme where video = '$rsDisplay[video]'";
$qrPagesxx = mysql_query($hitbul);
$hitbulx = mysql_fetch_array($qrPagesxx);?>
<a href="<?=$sitem?><?=$video_k?>/<?=($videobulx['baslik_seo'])?>" class="c-th">
<ins>
<img src="<?=$sitem?><?=($videobulx['resim'])?>" alt="<?=($videobulx['baslik'])?>" width="240" height="180">
<span class="amount">
<span class="hide_time"><?=($videobulx['sure'])?></span>
<span class="view"><?=($hitbulx['hit'])?></span>
<span><?=tarih($videobulx[tarih])?></span>
<span class="rat"><?=($hitbulx['puan'])?>%</span>
</span>
<span class="time"><?=($videobulx['sure'])?></span>
</ins>
<span class="title"><?=($videobulx['baslik'])?></span>
</a>
<?
}
}?>