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=8;
}
else
{
$page=$pg+1;
$llimit=8*$pg;
$mlimit=8;
}
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 indexpg where ".$dd1 ;
$rqry=mysqli_query($connect,$qry);
$rows=@mysqli_num_rows($rqry);
$loop=ceil($rows/12);
$sqlcat="select * from category 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 category 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";
?>
..:: Welcome to Natura Exim ::..
include ("top.php");?>
include ("left.php");?>
$qrynew="select * from indexpg where ".$dd1." order by id limit $llimit,$mlimit";
$qrypp=mysqli_query($connect,$qrynew);
$rno=mysqli_num_rows($qrypp);
if($rno >0){
$i=1;$k=0;
while($rowpp=mysqli_fetch_array($qrypp)){?>
if($i<4){ $i++;?>
}else{
$i=1;$k++;
echo " ";
}} ?>
} else{?>
print "Product Not Found In This Category"; ?>
}?>