""){ $cid=$_REQUEST['catid']; } if ($_REQUEST["subid"]<>""){ $pcatid=$_REQUEST['subid']; } if ($_REQUEST["spcatid"]<>""){ $spcatid=$_REQUEST['spcatid']; } if($cid<>"" && $pcatid<>"" && $spcatid<>""){ $dd1="subcat_id='".$pcatid."' and cat_id='".$cid."' and cat_id1='".$spcatid."'"; }elseif($cid<>"" && $pcatid<>""){ $dd1="subcat_id='".$pcatid."' and cat_id='".$cid."'"; }elseif($cid<>""){ $dd1="cat_id='".$cid."' "; }else{ $dd1="cat_id!=0"; } // Pagging $rpp = 12; // results per page $adjacents = 2; $page = intval($_GET["page"]); if($page<=0) $page = 1; //page url $reload = "new_arrival.php?catid=".$_REQUEST['catid']."&subid=".$_REQUEST['subid']."&spcatid=".$_REQUEST['spcatid'].""; // select appropriate results from DB: $sql = "select * from 15cup_ar_indexpg_2013 where pmonth=1 order by id desc"; $result = mysqli_query($connect,$sql); // count total number of appropriate listings: $tcount = mysqli_num_rows($result); // count number of pages: $tpages = ($tcount) ? ceil($tcount/$rpp) : 1; // total pages, last page number $count = 0; $i = ($page-1)*$rpp; $sqlcat="select * from 15cup_ar_category_2013 where catid='$cid'"; $qrycat=mysqli_query($connect,$sqlcat); $rowcat=mysqli_fetch_array($qrycat); $category=$rowcat['category']; $sqlpcat="select * from 15cup_ar_category_2013 where catid='".$_REQUEST['subid']."'"; $qrypcat=mysqli_query($connect,$sqlpcat); $rowpcat=mysqli_fetch_array($qrypcat); $pcategory=$rowpcat['category']; $sqlpcat1="select * from 15cup_ar_category_2013 where catid='".$_REQUEST['spcatid']."'"; $qrypcat1=mysqli_query($connect,$sqlpcat1); $rowpcat1=mysqli_fetch_array($qrypcat1); $spcategory=$rowpcat1['category']; ?> ..::Bindal Gems::..
Collection Of The Month
0){ while(($count<$rpp) && ($i<$tcount)) { mysql_data_seek($result,$i); $rsranking = mysqli_fetch_array($result);?>

$

Product Not Found In This Category!
";}?>