query("select * from tbl_page where page_id=4"); } else if($_REQUEST['proname'] == 'supplements'){ $page=$dbcon->query("select * from tbl_page where page_id=5"); }else if($_REQUEST['proname'] == 'pain-management'){ $page=$dbcon->query("select * from tbl_page where page_id=6"); }else if($_REQUEST['proname'] == 'kids-care'){ $page=$dbcon->query("select * from tbl_page where page_id=7"); } else{ $page=$dbcon->query("select * from tbl_page where page_id=12"); } $relpage=mysqli_fetch_assoc($page); $pro=$dbcon->query("select * from tbl_procat where cat_url='".$_REQUEST['proname']."'"); $rel=mysqli_fetch_assoc($pro); ?> <?=$relpage['page_name']?>

query("select * from tbl_product as pro left join tbl_procat as cat on cat.cat_id=pro.cat_id where pro.status=0 and cat_url='".$_REQUEST['proname']."' ORDER BY `product_name` ASC LIMIT 1 "); $row=mysqli_num_rows($product); if($row>0){ $relproduct=mysqli_fetch_assoc($product); ?>
<?=$relproduct['product_img']?>

", $relproduct['product_desc']); ?>

Product Combination

query("select * from tbl_product as pro left join tbl_procat as cat on cat.cat_id=pro.cat_id where pro.status=0 and cat_url='".$_REQUEST['proname']."'"); $row1=mysqli_num_rows($productt); if($row1>0){ ?>

Our Products

query("select * from tbl_product as pro left join tbl_procat as cat on cat.cat_id=pro.cat_id where pro.status=0 and cat_url='".$_REQUEST['proname']."'"); while($relproductt=mysqli_fetch_assoc($productt)){ if($relproductt['product_desc'] != ''){ ?>
<?=$relproductt['product_name']?>