|
Automotive Coupons
DISCOUNT TIRES
$user="tirestog_tires";
$host="localhost";
$password="mitchell";
$database="tirestog_tires";
$connection=mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
$db=mysql_select_db($database,$connection);
$limit=24;
$query_count="SELECT count(distinct category) as total FROM tires";
$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 tires order by category LIMIT $limitvalue,$limit";
$result = mysql_query($query) or die("Error: " . mysql_error());
?>
|
$limit=24;
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);
?>
|
|
Visit our new tire blog

Bridgestone R260 Tire
Bridgestone R260 Tire priced from $161.00. -
Click for Pricing on Bridgestone R260 Tire

Bridgestone R265 II Tire
Bridgestone R265 II Tire priced from $149.00. -
Click for Pricing on Bridgestone R265 II Tire

Bridgestone R265 Tire
Bridgestone R265 Tire priced from $136.00 to $155.00. -
Click for Pricing on Bridgestone R265 Tire

Bridgestone RE71 Denloc Tire
Bridgestone RE71 Denloc Tire priced from $275.00 to $310.00. -
Click for Pricing on Bridgestone RE71 Denloc Tire

Bridgestone S402 Tire
Bridgestone S402 Tire priced from $64.00. -
Click for Pricing on Bridgestone S402 Tire
|
TIRE STORES
Amazon
Bike Bandit
Nashbar
Northern Tool
Performance Bike
RideGear
Tire Rack
Walmart


|