Sports Categories
$user="sportsto_sportst";
$host="localhost";
$password="mitchell";
$database="sportsto_sports";
$connection=mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
$db=mysql_select_db($database,$connection);
$limit=100;
$query_count="SELECT count(distinct category) as total FROM sports";
$result_count=mysql_query($query_count);
$totalrows=mysql_num_rows($result_count);
$page = $_GET['page'];
$row=mysql_fetch_array($result_count);
$totalrows = $row['total'];
if(empty($page))
{
$page = 1;
}
$limitvalue = ($page * $limit) - $limit;
$query = "SELECT distinct category FROM sports order by category LIMIT $limitvalue,$limit";
$result = mysql_query($query) or die("Error: " . mysql_error());
?>
|
$limit=100;
if($page != 1){
$pageprev = $page-1;
}
$numofpages = ($totalrows / $limit);
for($i = 1; $i <= $numofpages; $i++){
if($i == $page)
echo($i." ");
else
echo("$i "); //removed $ in front of page
}
if (floor($totalrows / $limit) != 0) {
if($i == $page)
echo($i." ");
else
echo("$i ");
}
if(($totalrows - ($limit * $page)) > 0){
$pagenext = $page+ 1;
}else
mysql_free_result($result);
?>
|
|
Extreme Dimension Phantom Pro Predator Call System

Extreme Dimension Phantom Pro Predator Call System
An ideal tool for hunting predators, the Phantom Pro Predator Call System makes 12 sounds that can be used to lure game within ideal shooting range. Features an all-weather, 15-watt speaker guaranteed to raise curiosity. Click for Pricing on Extreme Dimension Phantom Pro Predator Call System

Extreme Dimension Pro Gobbler Sound Module
When used with a Phantom Pro Calling System, the Pro Gobbler Sound Module can be used to replicate the sounds of a turkey to lure that elusive gobbler. Click for Pricing on Extreme Dimension Pro Gobbler Sound Module

Extreme Dimension Pro Honker Sound Module
When used with a Phantom Pro Calling System, the Pro Honker Sound Module will make calling snow geese simple and easy. Click for Pricing on Extreme Dimension Pro Honker Sound Module

Extreme Dimension Pro Predator Sound Module
When used with a Phantom Pro Calling System, the Pro Whitetail Sound Module can be used to draw cautious predators. |