Jump to content

razera

New Members
  • Posts

    1
  • Joined

  • Last visited

razera's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. <?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>'; ?>
×
×
  • 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.