|
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

BBS RSII Sil w/Pol Stainless Lip Wheels
BBS RSII Sil w/Pol Stainless Lip Wheels priced from $540.00 to $769.00. BBS RSII Sil w/Pol Stainless Lip Wheels. -
Click for Pricing on BBS RSII Sil w/Pol Stainless Lip Wheels

BBS RW Bright Silver Paint Wheels
BBS RW Bright Silver Paint Wheels priced from $230.00 to $338.00. BBS RW Bright Silver Paint Wheels. -
Click for Pricing on BBS RW Bright Silver Paint Wheels

BBS RW Plasma Wheels
BBS RW Plasma Wheels priced from $347.00 to $473.00. BBS RW Plasma Wheels. -
Click for Pricing on BBS RW Plasma Wheels

BBS RWII Bright Sil w/Mach Lip Wheels
BBS RWII Bright Sil w/Mach Lip Wheels priced from $369.00 to $534.00. BBS RWII Bright Sil w/Mach Lip Wheels. -
Click for Pricing on BBS RWII Bright Sil w/Mach Lip Wheels

BBS RX Bright Silver Paint Wheels
BBS RX Bright Silver Paint Wheels priced from $216.00 to $404.00. BBS RX Bright Silver Paint Wheels. -
Click for Pricing on BBS RX Bright Silver Paint Wheels
|
TIRE STORES
Amazon
Bike Bandit
Nashbar
Northern Tool
Performance Bike
RideGear
Tire Rack
Walmart


|