prefix}category` WHERE status='active' ORDER BY sort_order Desc"; $get_category = get_records_sql($sql); //echo "
";print_r($get_category);echo "
";exit; $seo_keyword = optional_param('seo_keyword','',PARAM_RAW); $get_count_category = count_records('category','status','active'); $sql="SELECT name,id,seo_keyword,category FROM `{$CFG->prefix}sub_category` WHERE status='active' AND seo_keyword = '$seo_keyword' ORDER BY sort_order Desc"; $get_active_category = get_records_sql($sql); foreach($get_active_category as $v) { $active = $v->category; } //echo "
";print_r($get_active_category);echo "
";exit; if(empty($seo_keyword)) { $sql="SELECT name,id,seo_keyword FROM `{$CFG->prefix}category` WHERE status='active' ORDER BY sort_order Desc"; $default = get_record_sql($sql); $seo_keyword = $default->seo_keyword; } //$baseurl = 'products.html?seo_keyword='.$seo_keyword.'&page'; $baseurl = 'productsub_'.$seo_keyword.'.html?page'; ?>

PRODUCTS

    id;exit; if($active == $category->id) { $class = 'class="active"'; } else { $class = ''; } if($count == $get_count_category) { $class_li ='class="no-border"'; } else { $class_li=''; } ?>
  • >name; ?>
  • prefix}sub_category` WHERE status='active' AND category = ".$category->id; $get_sub_category = get_records_sql($sql); $flag = 0; //echo "
    ";print_r($get_sub_category);echo "
    ";exit; ?> seo_keyword == $seo_keyword) { $flag = 1; break; } ?>

Enquire Now

Name
Email
Comments
prefix}sub_category` WHERE status='active' AND seo_keyword = '$seo_keyword'"; $get_category_data = get_record_sql($sql_category); //echo "
";print_r($get_category_data);echo "
";exit; if(!empty($get_category_data)) { ?>

name; ?>

prefix."product WHERE status='active' and category=$get_category_data->id "; //print_object($sql_count); $totalcount = count_records_sql($sql_count); $sql_product="SELECT id,name,img,seo_keyword FROM `{$CFG->prefix}product` WHERE status='active' AND category=$get_category_data->id LIMIT $start,$perpage"; $get_product_data = get_records_sql($sql_product); if(!empty($get_product_data)) { foreach($get_product_data as $product_data) { ?> No Products in this category"; } } ?>