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);
?>
|
|
Barska SWAT Tactical Scope 8-32 x 44IR AC10548

Barska SWAT Tactical Scope 8-32 x 44IR AC10548
Designed with a glass-etched Mil-Dot reticle of 11-brightness-settings illumination, SWAT scopes feature external target turrets and a side turret-mounted parallax adjustment for easy and quick focusing. With its hair-splitting accuracy and impressive multi-coated optics, SWAT is ideal for varmint and long-range shooting in extreme sub-zero temperatures or searing desert heat.
Click for Pricing on Barska SWAT Tactical Scope 8-32 x 44IR AC10548

Barska Varmint Scope 4-16 x 50 AO AC10042
Featuring a large objective lens, multi-coated optics and easy-grip high turrets, the Varmint offers ease of use as well as twice the precision for critter hunting or long-range tactical shooting.
Click for Pricing on Barska Varmint Scope 4-16 x 50 AO AC10042

Barska Varmint Scope 6.5-20 x 50 AO AC10048
Featuring a large objective lens, multi-coated optics and easy-grip high turrets, the Varmint offers ease of use as well as twice the precision for critter hunting or long-range tactical shooting.
Click for Pricing on Barska Varmint Scope 6.5-20 x 50 AO AC10048

Bear Cub Jr. Bow Set
Here's all the intermediate archer needs to progress to the next level. The Jr. Bow features a reflex handle, adjustable sight pin, durable composite limbs and a hooded quiver with rubber clips to hold the included safety glass arrows.
Click for Pricing on Bear Cub Jr. Bow Set

Beta Chronograph
The Beta Chronograph gives you all the features of the Alpha plus: |