Search the Community

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