$prd_link_sql = mysql_query("select * from sub_cats order by sub_cat_id ASC LIMIT 1");
$rs_prd_link = mysql_fetch_array($prd_link_sql); ?>
$page = $_REQUEST['page'];
//$_SESSION['page'] = $page;
$id = $_REQUEST['scatid'];
$mid = $_REQUEST['mcatid'];
$sub_cats_rs = mysql_query("select * from sub_cats where sub_cat_id='$id'") or die(mysql_error());
$sub_cats = mysql_fetch_array($sub_cats_rs);
$cur_sub_cat_caption = $sub_cats['caption'];
$cur_sub_cat_id = $sub_cats['main_cat_id'];
$cur_main_cat_rs = mysql_query("select * from main_cats where main_cat_id='$cur_sub_cat_id'");
$cur_main_cats = mysql_fetch_array($cur_main_cat_rs);
?>
//-----------------------------------------------
//PAGING STARTS FROM HERE
//-----------------------------------------------
// how many rows to show per page
$rowsPerPage = 12;
$productsPerRow = 2;
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
// how many rows we have in database
$prdrs=mysql_query("Select * from products where sub_cat_id='$id' AND publish = 'y'");
$numrows=mysql_num_rows($prdrs);
$total_prds=$numrows;
// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);
if($maxPage==0) {
$maxPage=1;
}else{
$maxPage=$maxPage;
}
$self = $_SERVER['PHP_SELF']."?mcatid=$cur_sub_cat_id&scatid=$id";
$prdrs=mysql_query("Select * from products where sub_cat_id='$id' AND publish = 'y' ORDER BY sorting_order LIMIT $offset, $rowsPerPage");
$prdrs_scroll =mysql_query("Select * from products where publish = 'y' AND featured = 'y' ORDER BY sorting_order") or die(mysql_error());
?>
require_once('browser_detection/Browser.php');
$browser = new Browser();
if( $browser->getBrowser() == Browser::BROWSER_FIREFOX && $browser->getVersion() >= 2 ) {
?>
}else{
?>
}
?>
::::::::::::: Nargis Impex - Manufacturers and Exporters of Boxing, MMA & Martial Art Goods