""){ if($_REQUEST[p_id] <> ""){ $sql = "select * from product_db where g_id=$_REQUEST[g_id] and subcate_id=$_REQUEST[subcate_id] and p_id=$_REQUEST[p_id]"; $var[body] = products_detail($sql); }else{ if($_REQUEST[subcate_id] <>"")$ex = " and subcate_id = '$_REQUEST[subcate_id]'"; else $ex = ""; $file = "products_detail.html"; $sql = "select * from product_db where g_id = '$_REQUEST[g_id]' $ex"; //page base url// if($_REQUEST[page] == "")$page = 1; else $page = $_REQUEST[page]; //no. of records per page $per = 5; $url = "products.php"; $normal_class = "normal_page"; $current_class = "current_page"; $all_record = cal_record($sql); $all_page = cal_page($sql,$per); $sql = sql_find_page($sql,$page,$per); $var[page] = show_page($all_page,$per,$page,$_REQUEST[g_id],$_REQUEST[subcate_id],$url,$normal_class,$current_class,$keyword); // $var[body] = list_top_group($sql,"products"); if ($_REQUEST['subcate_id']<>""){ $var[body] = list_products($sql); }else{ $var[body] = product_cat($sql); } $var[shortcut] = "Products"; if($_REQUEST[g_id] <> ""){ $result_category = mysql_query("select * from category where store_id ='$section' and g_id = '$_REQUEST[g_id]'"); if(mysql_num_rows($result_category)){ $category_name = mysql_result($result_category,0,"g_name_".$language); $var[shortcut] .="     ".$category_name.""; } } if($_REQUEST[subcate_id] <> ""){ $result_subcategory = mysql_query("select * from subcategory where subcate_id = '$_REQUEST[subcate_id]'"); if(mysql_num_rows($result_subcategory)){ $subcategory_name = mysql_result($result_subcategory,0,"subcatename_".$language); $var[shortcut] .="     ".$subcategory_name.""; } } $var[shortcut] .= ""; } }else{ $sql = "select * from category where store_id ='$section'"; $var[body] = list_top_group($sql,"$section"); } $var[top_banner] = top_banner(); parse_file($file,$var); ?>