if($_REQUEST['sub_cat']!="") //if(!empty($_GET['sub_cat'])) { $category_ide=$_REQUEST['sub_cat']; }else{ $category_ide=$_REQUEST['category_id']; } //$page_query = mysql_query("select * from products where category_id='$category_ide' order by sort ") or die(mysql_error()); // $noRows=mysql_num_rows($page_query); $resultperpage=12; $totalpages=ceil($noRows/$resultperpage); if(isset($_GET['page'])){ $page=$_GET['page']; }else{ $page=1; } if($page==1){ $from=0; }else{ $from=$resultperpage*$page-$resultperpage; } $to=$from-$resultperpage+1; $rsSearch=mysql_query("select * from products where category_id='$category_ide' order by sort "); //$debat=mysql_fetch_array($rsSearch); ?>
|