";
// echo "| Number of results: $resultsnumber | ";
//PAGINATION CODE
$query = "SELECT COUNT(*) as num FROM $Deals";
//$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];
// echo "Hi $total_pages";
$total_pages = $resultsnumber;
// echo "Hi $total_pages";
/* Setup vars for query. */
$targetpage = "dealp.php"; //your file name (the name of this file)
$limit = 20; //how many items to show per page
$page = $_GET['page'];
if($page)
$start = ($page - 1) * $limit; //first item to display on this page
else
$start = 0; //if no page var is given, set start to 0
/* Get data. */
//echo "Hi $start and $limit";
//$sql="SELECT * FROM Deals where display_women='Y'";
// Fix man SQL statement $sql = "SELECT * FROM Deals LIMIT $start, $limit";
//New SQL statement with LIMIT clause
$sql = "SELECT * FROM Deals where display_default='Y' LIMIT $start, $limit";
//echo $sql;
$result = mysql_query($sql);
/* Setup page vars for display. */
if ($page == 0) $page = 1; //if no page var is given, default to 1.
$prev = $page - 1; //previous page is page - 1
$next = $page + 1; //next page is page + 1
$lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1; //last page minus 1
/*
Now we apply our rules and draw the pagination object.
We're actually saving the code to a variable in case we want to draw it more than once.
*/
$pagination = "";
if($lastpage > 1)
{
$pagination .= "\n";
}
echo $pagination;
?>
Popular deals in all category
.