host;
$DB_USER = $config->user;
$DB_PASS = $config->password;
$DB_NAME = $config->database;
// connect to db
$link = mysql_connect($DB_HOST, $DB_USER, $DB_PASS);
if (!$link) {
die('Not connected : ' . mysql_error());
}
$idget = $_GET['id'];
$rowsPerPage = 1;
// 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;
//$query = "SELECT * FROM `".$DB_NAME."`.`our_collection_products` WHERE id='$idget' and visible=1 ORDER BY sort_order LIMIT $offset, $rowsPerPage";.
//$query = " SELECT val FROM randoms " .
// " LIMIT $offset, $rowsPerPage";
//$result = mysql_query($query) or die('Error, query failed');
$query = "SELECT COUNT(id) AS numrows FROM `".$DB_NAME."`.`corporate_sales` WHERE visible=1";
//echo $query;
$result = mysql_query($query) or trigger_error(mysql_error());
//$subformresults = mysql_query($subformQuery ) or trigger_error(mysql_error());
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);
// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nav .= "$page "; // no need to create a link to current page
}
else
{
$nav .= " $page ";
}
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " [Prev] ";
$first = " [First Page] ";
}
else
{
$prev = ' '; // we're on page one, don't print previous link
$first = ' '; // nor the first page link
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " [Next] ";
$last = " [Last Page] ";
}
else
{
$next = ' '; // we're on the last page, don't print next link
$last = ' '; // nor the last page link
}
// print the navigation link
//echo $first . $prev . $nav . $next . $last;
echo $nav ;
?>
