categories from e-shop

[razera]

<?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>';

?>


 

[fastsol]

Umm what's the question?  You can't just post code with not explanation of what your issue is and expect people to do anything to help you.

[ignace]

No question. No topic.