select($sql_products); $count_products = count($db_products); if($db_products[0]['product_cat']!=""){ $sql_cat = "select catid,catname from category where catid=".$db_products[0]['product_cat']; $db_cat = $obj->select($sql_cat); $catname = $db_cat[0]['catname']; } if($db_products[0]['product_subcat']>0){ $sql_subcat = "select subcatid,subcatname from subcategory where subcatid=".$db_products[0]['product_subcat']; $db_subcat = $obj->select($sql_subcat); $subcatname = $db_subcat[0]['subcatname']; } ?>

Product Details