Merhaba Arkadaşlar
Mysql veritabanımda 2 tabloyu inner join ile birleştirerek 4 ayrı kategoriden veriler çekip listeletiyorum ama veritabanımda veri yok ise hata veriyor, 1 tane veri varsa diğer 3 div tablolarında hatalar vererek gidiyor, veritabanımda ayrı kategorilere ait 4 tane veri var ise hata vermiyor, bu hatanın verme sebebi veritabanımda veri olmamasından, rowCount ile yapmaya çalıştım yapamadım, kod bloğum aşağıdaki gibi bu konuda yardımcı olabilirmisiniz,
teşekkürler
<div class="row gutter--15">
<?php
$sor=$db->prepare("SELECT * from blog inner join blogkategori on blog.kategori=blogkategori.id ORDER BY rand() limit 4");
$sor->execute();
$cek=$sor->fetchAll(PDO::FETCH_ASSOC);
?>
<div class="col-md-6">
<div class="post--item post--layout-1 post--title-larger">
<div class="post--img">
<a title="<?php echo $cek[0]['kadi'];?>" href="blog-details/<?php echo $cek[0]['seo'];?>" class="thumb"><img src="/uploads/bloglar/<?php echo $cek[0]['kapak'];?>" alt="<?php echo $cek[0]['adi'];?>"></a>
<a title="<?php echo $cek[0]['kadi'];?>" href="#" class="cat"><?php echo $cek[0]['kadi'];?></a>
<div class="post--info">
<ul class="nav meta">
<li><a href="#"><?php echo $cek[0]['tarih'];?></a></li>
</ul>
<div class="title">
<h2 class="h4">
<a href="blog-details/<?php echo $cek[0]['seo'];?>" class="btn-link"><?php echo $cek[0]['adi'];?></a>
</h2>
</div>
</div>
</div>
</div>
</div>
<div class="col-md-6">
<div class="row gutter--15">
<div class="col-xs-6 col-xss-12">
<div class="post--item post--layout-1 post--title-large">
<div class="post--img">
<a title="<?php echo $cek[1]['adi'];?>" href="blog-details/<?php echo $cek[1]['seo'];?>" class="thumb"><img src="/uploads/bloglar/<?php echo $cek[1]['kapak'];?>" alt="<?php echo $cek[1]['adi'];?>"></a>
<a title="<?php echo $cek[1]['kadi'];?>" href="#" class="cat"><?php echo $cek[1]['kadi'];?></a>
<div class="post--info">
<ul class="nav meta">
<li>
<a href="#"><?php echo $cek[1]['tarih'];?></a>
</li>
</ul>
<div class="title">
<h2 class="h4">
<a title="<?php echo $cek[1]['adi'];?>" href="blog-details/<?php echo $cek[1]['seo'];?>" class="btn-link"><?php echo $cek[1]['adi'];?></a>
</h2>
</div>
</div>
</div>
</div>
</div>
<div class="col-xs-6 hidden-xss">
<div class="post--item post--layout-1 post--title-large">
<div class="post--img">
<a title="<?php echo $cek[2]['adi'];?>" href="blog-details/<?php echo $cek[2]['seo'];?>" class="thumb"><img src="/uploads/bloglar/<?php echo $cek[2]['kapak'];?>" alt="<?php echo $cek[2]['adi'];?>"></a>
<a title="<?php echo $cek[2]['kadi'];?>" href="#" class="cat"><?php echo $cek[2]['kadi'];?></a>
<div class="post--info">
<ul class="nav meta">
<li><a href="#"><?php echo $cek[2]['tarih'];?></a></li>
</ul>
<div class="title">
<h2 class="h4">
<a title="<?php echo $cek[2]['adi'];?>" href="blog-details/<?php echo $cek[2]['seo'];?>" class="btn-link"><?php echo $cek[2]['adi'];?></a>
</h2>
</div>
</div>
</div>
</div>
</div>
<div class="col-sm-12 hidden-sm hidden-xs">
<div class="post--item post--layout-1 post--title-larger">
<div class="post--img">
<a title="<?php echo $cek[3]['adi'];?>" href="blog-details/<?php echo $cek[3]['seo'];?>" class="thumb"><img src="/uploads/bloglar/<?php echo $cek[3]['kapak'];?>" alt=""></a>
<a title="<?php echo $cek[3]['kadi'];?>" href="#" class="cat"><?php echo $cek[3]['kadi'];?></a>
<div class="post--info">
<ul class="nav meta">
<li><a href="#"><?php echo $cek[3]['tarih'];?></a></li>
</ul>
<div class="title">
<h2 class="h4">
<a title="<?php echo $cek[3]['adi'];?>" href="blog-details/<?php echo $cek[3]['seo'];?>" class="btn-link"><?php echo $cek[3]['adi'];?></a>
</h2>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>