0){
$result = db_query("select product_id,product_name,product_code from products a join sub_categories b using(subcat_id) where pstatus='Active' and sstatus='Active' and subcat_id='$scatid' order by product_name asc");
$data = mysql_fetch_assoc($resultP);
$scat_name = mysql_one_data("select sub_cat_name from sub_categories where subcat_id='$scatid' and sstatus='Active'");
}else{
$result = db_query("select product_id,product_name,product_code from products a join categories b using(category_id) where pstatus='Active' and cstatus='Active' and category_id='$mcid' order by product_name asc");
}
$mcat_name = mysql_one_data("select cat_name from categories where category_id='$mcid' and cstatus='Active'");
?>