<li class="menu-item-has-children" ><a href="javascript:void(0)"  title="ÜRÜNLERİMİZ" >ÜRÜNLERİMİZ</a>
                                      <ul class="sub-menu">
                                          <?php 

             $kategorisor=$db->prepare("SELECT * FROM katagoriler where durum=:durum order by id ASC");
             $kategorisor->execute(array(
                'durum' => 1
            ));

             while($kategoricek=$kategorisor->fetch(PDO::FETCH_ASSOC)) { 

                $kategori_id=$kategoricek['id'];
                ?>

                <li><a href="kategoriler-<?=seo($kategoricek['baslik'])."-".$kategoricek['id'] ?>"  title="<?php echo $kategoricek['baslik'] ?>" ><?php echo $kategoricek['baslik'] ?></a>


            
                <?php 

             $query = $db->prepare("select * from altkat inner join katagoriler on  
  
    katagoriler.id = altkat.kat_id where baslik=?
  
  ");
   
   $query->execute(array($link));
   $goster =  $query->fetchAll(PDO::FETCH_ASSOC);
   $x      = $query->rowCount();  
                ?>
                <?php          
           
          foreach($goster as $row){
              
              ?>
              <ul class="sub-menu">
                <li><a href="kategoriler-<?=seo($row['baslik'])."-".$row['id'] ?>"><?php echo $row["baslik"];?></a></li>
            </ul>

            <?php } ?>
                    </li>

                <?php } ?>