include("admin/dbconnect.php");
$result5 = mysql_query("SELECT * FROM info WHERE info_id=1")
or die(mysql_error());
// loop through results of database query, displaying them in the table
while($row = mysql_fetch_array( $result5 )) {
$info_shop_items = $row['info_shop_items'];
}
// get results from database
$result = mysql_query("SELECT * FROM items WHERE status = 'Active' And category = '$category' And qty_on_hand > 0 Or status = 'Active' And category2 = '$category' And qty_on_hand > 0 Or status = 'Active' And category3 = '$category' And qty_on_hand > 0 ORDER BY price $sort")
or die(mysql_error());
echo "( ";
$total_results = mysql_num_rows($result);
if ($info_shop_items == 0 )
{
$per_page = "12"; //limit of archived results per page.
} else {
$per_page = $info_shop_items; //limit of archived results per page.
}
$total_pages = ceil($total_results / $per_page); //total number of pages
// This is the beginning of the Previous/Next Navigation
if (isset($_GET['page']) && is_numeric($_GET['page']))
{
$show_page = $_GET['page'];
// make sure the $show_page value is valid
if ($show_page > 0 && $show_page <= $total_pages)
{
$start = ($show_page -1) * $per_page;
$end = $start + $per_page;
}
else
{
// error - show first set of results
$start = 0;
$end = $per_page;
}
}
else
{
// if page isn't set, show first set of results
$start = 0;
$end = $per_page;
$show_page =1;
}
echo $total_results;
echo " found )";
if ($total_results > 0)
{
echo " Page $show_page of $total_pages";
}
echo "
";
echo "
";
if ($show_page > 1)
{
$page = $show_page-1;
$category_link = $category;
$category_link = str_replace(" ", "-", $category_link);
echo " ";
}
if($show_page != $total_pages && $total_pages != 0 || $show_page == 0 && $total_pages >= 2)
{
$page = $show_page+1;
$category_link = str_replace("-", " ", $category);
echo " ";
}
echo "";
echo "
";
echo "
";
echo "