Jump to content


Photo

categories from e-shop

categories from e-shop

  • This topic is locked This topic is locked
2 replies to this topic

#1 razera

razera

    Newbie

  • New Members
  • Pip
  • 1 posts

Posted 09 September 2013 - 11:59 AM

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

?>


 



#2 fastsol

fastsol

    Advanced Member

  • Members
  • PipPipPip
  • 491 posts
  • LocationMinnesota

Posted 09 September 2013 - 12:30 PM

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.


You never know everything, I learn everday!

http://amecms.com

http://amewebdesigns.com


#3 ignace

ignace

    Now mod flavored

  • Moderators
  • 6,249 posts
  • LocationBelgium

Posted 18 September 2013 - 03:08 AM

No question. No topic.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com