rendered paste body<?php require_once('Connections/grange.php'); ?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$colname_category = "-1";
if (isset($_GET['recordID'])) {
$colname_category = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
}
mysql_select_db($database_grange, $grange);
$query_category = sprintf("SELECT * FROM categories_description WHERE categories_id = %s", $colname_category);
$category = mysql_query($query_category, $grange) or die(mysql_error());
$row_category = mysql_fetch_assoc($category);
$totalRows_category = mysql_num_rows($category);
$colname_catimage = "-1";
if (isset($_GET['recordID'])) {
$colname_catimage = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
}
mysql_select_db($database_grange, $grange);
$query_catimage = sprintf("SELECT * FROM categories WHERE categories_id = %s", $colname_catimage);
$catimage = mysql_query($query_catimage, $grange) or die(mysql_error());
$row_catimage = mysql_fetch_assoc($catimage);
$totalRows_catimage = mysql_num_rows($catimage);
$colname_catprodswitch = "-1";
if (isset($_GET['recordID'])) {
$colname_catprodswitch = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
}
mysql_select_db($database_grange, $grange);
$query_catprodswitch = sprintf("SELECT * FROM products_to_categories WHERE categories_id = %s", $colname_catprodswitch);
$catprodswitch = mysql_query($query_catprodswitch, $grange) or die(mysql_error());
$row_catprodswitch = mysql_fetch_assoc($catprodswitch);
$totalRows_catprodswitch = mysql_num_rows($catprodswitch);
$sql_recordID = mysql_escape_string($_GET['recordID']);
$maxRows_productdesc = 1;
$pageNum_productdesc = 0;
if (isset($_GET['pageNum_productdesc'])) {
$pageNum_productdesc = $_GET['pageNum_productdesc'];
}
$startRow_productdesc = $pageNum_productdesc * $maxRows_productdesc;
mysql_select_db($database_grange, $grange);
$query_productdesc = "SELECT * FROM products_description join products_to_categories on products_description.products_id = products_to_categories.products_id WHERE products_to_categories.categories_id = products_to_categories.categories_id and products_to_categories.categories_id = '$sql_recordID'";
$query_limit_productdesc = sprintf("%s LIMIT %d, %d", $query_productdesc, $startRow_productdesc, $maxRows_productdesc);
$productdesc = mysql_query($query_limit_productdesc, $grange) or die(mysql_error());
$row_productdesc = mysql_fetch_assoc($productdesc);
if (isset($_GET['totalRows_productdesc'])) {
$totalRows_productdesc = $_GET['totalRows_productdesc'];
} else {
$all_productdesc = mysql_query($query_productdesc);
$totalRows_productdesc = mysql_num_rows($all_productdesc);
}
$totalPages_productdesc = ceil($totalRows_productdesc/$maxRows_productdesc)-1;
$maxRows_productsimage = 1;
$pageNum_productsimage = 0;
if (isset($_GET['pageNum_productsimage'])) {
$pageNum_productsimage = $_GET['pageNum_productsimage'];
}
$startRow_productsimage = $pageNum_productsimage * $maxRows_productsimage;
mysql_select_db($database_grange, $grange);
$query_productsimage = "SELECT * FROM products join products_to_categories on products.products_id = products_to_categories.products_id WHERE products_to_categories.categories_id = products_to_categories.categories_id and products_to_categories.categories_id = '$sql_recordID'";
$query_limit_productsimage = sprintf("%s LIMIT %d, %d", $query_productsimage, $startRow_productsimage, $maxRows_productsimage);
$productsimage = mysql_query($query_limit_productsimage, $grange) or die(mysql_error());
$row_productsimage = mysql_fetch_assoc($productsimage);
if (isset($_GET['totalRows_productsimage'])) {
$totalRows_productsimage = $_GET['totalRows_productsimage'];
} else {
$all_productsimage = mysql_query($query_productsimage);
$totalRows_productsimage = mysql_num_rows($all_productsimage);
}
$totalPages_productsimage = ceil($totalRows_productsimage/$maxRows_productsimage)-1;
$queryString_productdesc = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_productdesc") == false &&
stristr($param, "totalRows_productdesc") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_productdesc = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_productdesc = sprintf("&totalRows_productdesc=%d%s", $totalRows_productdesc, $queryString_productdesc);
$queryString_productsimage = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_productsimage") == false &&
stristr($param, "totalRows_productsimage") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_productsimage = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_productsimage = sprintf("&totalRows_productsimage=%d%s", $totalRows_productsimage, $queryString_productsimage);
?>
this is the paging code
<td width="23%" align="center"><?php if ($pageNum_productdesc > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_productdesc=%d%s", $currentPage, 0, $queryString_productdesc); ?>">First</a>
<?php } // Show if not first page ?>
</td>
<td width="31%" align="center"><?php if ($pageNum_productdesc > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_productdesc=%d%s", $currentPage, max(0, $pageNum_productdesc - 1), $queryString_productdesc); ?>">Previous</a>
<?php } // Show if not first page ?>
</td>
<td width="23%" align="center"><?php if ($pageNum_productdesc < $totalPages_productdesc) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_productdesc=%d%s", $currentPage, min($totalPages_productdesc, $pageNum_productdesc + 1), $queryString_productdesc); ?>">Next</a>
<?php } // Show if not last page ?>
</td>
<td width="23%" align="center"><?php if ($pageNum_productdesc < $totalPages_productdesc) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_productdesc=%d%s", $currentPage, $totalPages_productdesc, $queryString_productdesc); ?>">Last</a>
<?php } // Show if not last page ?>
</td>