include("cf/conn.php"); $_SESSION['REFERER']=$_SERVER['HTTP_REFERER']; $matelid=$stoneid=$pcatid=$cid=""; if ($_REQUEST["cid"]<>"" && isset($_REQUEST["cid"])){ $_SESSION['cid']=$_REQUEST["cid"]; $cid=$_REQUEST["cid"]; }else{ $cid=$_SESSION['cid']; } if (isset($_REQUEST["subcatid"]) && $_REQUEST["subcatid"]<>""){ $_SESSION['pcatid']=$_REQUEST["subcatid"]; $pcatid=$_SESSION['pcatid']; } $pg=$_REQUEST['pg']; if($pg=="") { $page=1; $llimit=0; $mlimit=12; } else { $page=$pg+1; $llimit=12*$pg; $mlimit=12; } if($cid<>"" && $pcatid<>""){ $dd="subcat='$pcatid' and cat_id='".$cid."'"; }elseif($cid<>""){ $dd="and cat_id='".$cid."'"; } if($cid<>"" && $pcatid<>""){ $dd1="subcat='$pcatid' and cat_id='".$cid."'"; }else{ $dd1="cat_id='".$cid."'"; } $qry="select * from indexpgm where ".$dd1 ; $rqry=mysqli_query($connect,$qry); $rows=@mysqli_num_rows($rqry); $loop=ceil($rows/12); $sqlcat="select * from categorym where catid='$cid'"; $qrycat=mysqli_query($connect,$sqlcat) or die(mysql_error()); $rowcat=mysqli_fetch_array($qrycat); $category1=$rowcat[category]; $mdisc=$rowcat[disc]; if ($_REQUEST['subcatid']<>""){ $sqlpcat="select * from categorym where catid='".$_REQUEST['subcatid']."'"; $qrycat=mysqli_query($connect,$sqlpcat) or die(mysql_error()); $rowcat=mysqli_fetch_array($qrycat); $pcategory=$rowcat[category]; $pdisc=$rowcat[disc]; } $dd2="productsearch.php?cid=$cid"; ?>
| include ("top1.php");?> | ||||||||||||||||||||
|
|
|||||||||||||||||||
|
||||||||||||||||||||