""){ $_SESSION['cid']=$_REQUEST["cid"]; $cid=$_SESSION['cid']; }else{ $cid=$_REQUEST['cid']; //$cid=$_SESSION['cid']; } if ($_REQUEST["pcatid"]<>""){ $_SESSION['pcatid']=$_REQUEST["pcatid"]; $pcatid=$_SESSION['pcatid']; }else{ //$pcatid=$_SESSION['pcatid']; $pcatid=$_REQUEST['pcatid']; } if ($_REQUEST["spcatid"]<>""){ $_SESSION['spcatid']=$_REQUEST["spcatid"]; $spcatid=$_SESSION['spcatid']; }else{ $spcatid=$_SESSION['spcatid']; } if ($_REQUEST["gems"]<>""){ $_SESSION['gems']=$_REQUEST["gems"]; $gems=$_SESSION['gems']; }else{ $gems=$_SESSION['gems']; } $pg=$_REQUEST['pg']; if($pg=="") { $page=1; $llimit=0; $mlimit=9; } else { $page=$pg+1; $llimit=9*$pg; $mlimit=9; } if($cid<>"" && $pcatid<>""){ $dd="and subcat_id='".$pcatid."' and cat_id='".$cid."'"; }elseif($cid<>""){ $dd="and cat_id='".$cid."'"; } if($cid<>"" && $pcatid<>""){ $dd1="subcat_id='".$pcatid."' and cat_id='".$cid."'"; }elseif($cid<>""){ $dd1="cat_id='".$cid."'"; } $qry="select * from photoindexpg where ".$dd1 ; $rqry=mysqli_query($connect,$qry); $rows=@mysqli_num_rows($rqry); $loop=ceil($rows/9); $sqlcat="select * from photocategory where catid='$cid'"; $qrycat=mysqli_query($connect,$sqlcat); $rowcat=mysqli_fetch_array($qrycat); $category=$rowcat[category]; $sqlpcat="select * from photocategory where catid='".$_REQUEST['pcatid']."'"; $qrypcat=mysqli_query($connect,$sqlpcat); $rowpcat=mysqli_fetch_array($qrypcat); $pcategory=$rowpcat[category]; ?>

"" && $pcatid<>""){ $dd2="productsearch1.php?cid=$cid&pcatid=$pcatid"; }elseif($cid<>"" ){ $dd2="productsearch1.php?cid=$cid"; } $sqlpp="select * from photoindexpg where (".$dd1." ) order by id limit $llimit,$mlimit"; $qrypp=mysqli_query($connect,$sqlpp); $rno=mysqli_num_rows($qrypp); if($rno >0){ $i=1; while($rowpp=mysqli_fetch_array($qrypp)) { $item++; }} ?>