$page = $_GET['page']; } else { $page = 1; } if ($page < 1) { $page = 1; } //echo $query; $limit = getPaginationLimit(); $sql_category = " SELECT * FROM " . $tableprefix . "categories WHERE parent_id LIKE " . GetSQLValueString($catid, "text") . " ORDER BY category_name "; $result_category = mysql_query($sql_category) or die(mysql_error()); $totalrows = mysql_num_rows(mysql_query($sql_category)); if ($limit == 0) { $limit = 12; } $sql_qr = doAjaxpaging($sql_category, $page, $limit); //echo $sql_qr; $result = mysql_query($sql_qr) or die(mysql_error()); $prodimagedir = "products/"; $totalRowCount = $totalrows; ?> <div class="pcm_productlisting" > <!--new design--> <?php while ($row_category = mysql_fetch_array($result)) { $sql_route_catalog = "SELECT route,category_id from " . $tableprefix . "categories cat where cat.route REGEXP '^" . $row_category['category_id'] . ",|,^" . $row_category['category_id'] . "|," . $row_category['category_id'] . ",|," . $row_category['category_id'] . "\$|^" . $row_category['category_id'] . "\$' "; $rs_route_catalog = mysql_query($sql_route_catalog) or die(mysql_error()); $current_catlist_catalog = array(); if (mysql_num_rows($rs_route_catalog) > 0) {
} if (isset($_GET['page'])) { $page = $_GET['page']; } else { $page = 1; } if ($page < 1) { $page = 1; } $limit = getPaginationLimit(); if ($limit <= 0) { $limit = 12; } $result = mysql_query($sql_seller_feedback) or die(mysql_error()); $totalrows = mysql_num_rows($result); $sql_qr = doAjaxpaging($sql_seller_feedback, $page, $limit); //echo $sql_qro $rs_seller_feedback = mysql_query($sql_qr) or die(mysql_error()); ?> <script language="javascript" type="text/JavaScript" src="<?php echo SITE_URL; ?> /js/product-rating_seller.js"></script> <script language="javascript" src="<?php echo SITE_URL; ?> /js/jquery-rating.js"></script> <div class="vendortab_pannel_content2">
$newitem_image = "new_items_h.gif"; $pageHeading = "New Items"; } $prodimagedir = SITE_URL . "/products/"; if (isset($_GET['page'])) { $page = $_GET['page']; } else { $page = 1; } if ($page < 1) { $page = 1; } $limit = 12; //echo $sql; //$sql_qr=dopaging($sql,'',$limit); $sql_qr = doAjaxpaging($sql, $page, $limit); $result = mysql_query($sql_qr) or die(mysql_error()); $totalrows = mysql_num_rows(mysql_query($sql)); //get products ends ?> <!--<script language="javascript" type="text/JavaScript" src="<?php echo SITE_URL; ?> /js/jquery.js"></script> <script language="javascript" type="text/JavaScript" src="<?php echo SITE_URL; ?> /js/pagingHomepage.js"></script>--> <div class="tab_pannel_subheading"><h4><?php printElement($pageHeading); ?>
$result = mysql_query($query) or die(mysql_error()); $totalrows = mysql_num_rows($result); $limit = getPaginationLimit(); if ($limit == 0) { $limit = 12; } if ($_REQUEST['txtPageLimit'] == '') { $limit = $totalrows; } if (isset($_REQUEST['txtPageLimit']) && $_REQUEST['txtPageLimit'] != '') { $limit = $_REQUEST['txtPageLimit']; $paginglimit = 0; } else { $paginglimit = $limit; } $sql_qr = doAjaxpaging($query, $page, $limit); $result = mysql_query($sql_qr) or die(mysql_error()); $prodimagedir = "products/"; $totalRowCount = $totalrows; ?> <div class="pcm_productlisting_topbox"> <div class="pcm_page_limit" style="float: left;"> <?php /*echo $showproductlisting;*/ ?> <input type="hidden" name="startlimit" id ="startlimit" value="<?php echo $paginglimit; ?>