Jump to content

categories from e-shop


razera

Recommended Posts

<?php
   
   echo '<div id="categoriesBox">';
   echo 'Categories';
   echo '<table width="100%" cellpadding="2">';
   foreach($Categories->getFields() as $key => $value){
      $query = "SELECT COUNT(products_id) as 'count' FROM sklep_products WHERE products_cat_id='".$value['categories_id']."'";
      $DB->makeQuery($query);
      if($DB->getNumRows()>0){
         $count = $DB->getField(0,0);
      }
      else {
         $count = 0;
      }
      if($value['categories_parent_id']==0){
         echo '<tr><td>>> <a href="index.php?category='.$value['categories_id'].'">'.$value['categories_name'].'('.$count.')'.'</a></td></tr>';
         foreach($Categories->getFields() as $key2 => $value2){
            $query = "SELECT COUNT(products_id) as 'count' FROM sklep_products WHERE products_cat_id='".$value2['categories_id']."'";
            $DB->makeQuery($query);
            if($DB->getNumRows()>0){
               $count = $DB->getField(0,0);
            }
            else {
               $count = 0;
            }
            if($value2['categories_parent_id'] == $value['categories_id']){
               echo '<tr><td><div style="margin:0 0 0 35px;">> <a href="index.php?category='.$value2['categories_id'].'">'.$value2['categories_name'].'('.$count.')'.'</a></div></td></tr>';
            }
         }
      }

   }
   echo '</table>';
   echo '</div>';

?>


 

Link to comment
Share on other sites

  • 2 weeks later...
Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.