2014-05-19

help me with my problem

mysql_select_db($database_localhost, $localhost);
$query_Recordset1 = "SELECT * FROM sessions WHERE sessions.id = $id";
$Recordset1 = mysql_query($query_Recordset1, $localhost) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

mysql_select_db($database_localhost, $localhost);
$query_Recordset2 = "SELECT * FROM zones WHERE $zip BETWEEN zip1 AND zip2";
$Recordset2 = mysql_query($query_Recordset2, $localhost) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);

mysql_select_db($database_localhost, $localhost);
$query_Recordset3 = "SELECT * FROM multipliers";
$Recordset3 = mysql_query($query_Recordset3, $localhost) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);

$weight = 0;
$vars = explode (":",$row_Recordset1['vars']);
$values = explode (":",$row_Recordset1['values']);
$i = 0;
foreach($vars as $v) {
$$v = $values[$i];
$i++; }

$discount = @($discount/100)+1;
$Sub = number_format(($Sub*$discount), 2, '.', '');

$weight += $Qty1*3;
$weight += $Qty2*8;
$weight += $Qty3*3;
$weight += $Qty4*12;
$weight += $Qty5*59;
$weight += $Qty6*3;
$weight += $Qty7*11;
$weight += $Qty8*56;
$weight += $Qty9*3;
$weight += $Qty10*12;
$weight += $Qty11*65;
$weight += $Qty12*1;
$weight += $Qty13*3;
$weight += $Qty14*11;
$weight += $Qty15*55;
$weight += $Qty16*10;

//**************************************************************
$qts = ($Qty1+$Qty3+$Qty6+$Qty9+$Qty13)*3.27;
$gals = ($Qty2+$Qty4+$Qty7+$Qty10+$Qty14)*4.06;
$gal5 = ($Qty5+$Qty8+$Qty11+$Qty15)*8.15;
//**************************************************************

$zone = $row_Recordset2['zone'];
$rate[2] = 3.94;
$rate[3] = 4.95;
$rate[4] = 4.98;
$rate[5] = 7.01;
$rate[6] = 8.07;
$rate[7] = 10.09;
$rate[8] = 12.20;

//**************************************************************

$query = "SELECT * FROM multipliers WHERE $zone = zone";
$Recordset2 = mysql_query($query, $localhost) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$mult1 = $row_Recordset2['mult1'];
$mult2 = $row_Recordset2['mult2'];
$mult3 = $row_Recordset2['mult3'];
$icosts = ($Qty8*5)+$Qty7+$Qty4+$Qty10+$Qty14;
$hcosts = ($gal5 + $gals + $Qty12)*.3;
$qts *= $mult3;
$gals *= $mult2;
$gal5 *= $mult1;
$shipc = $qts+$gals+$gal5 + $icosts + $hcosts + $rate[$zone];
$shipx = $Qty2+$Qty4+$Qty7+$Qty10+$Qty14+(($Qty5+$Qty8+$Qty11+$Qty15)5)+($Qty12.1);
$shipz = $weight * $rate[$zone];
$shipt = $shipc + $shipx;
$shipf = number_format(($shipt), 2, '.', '');
$Tot = number_format(($shipt+$Sub), 2, '.', '');
}
//**************************************************************

if ($Submit == "Continue to Secure Checkout") {
mysql_select_db($database_localhost, $localhost);
$query_Recordset4 = "REPLACE INTO clients (email, fname, lname, company, address1, address2, city, state, zip, phone) VALUES ('$email', '$fname', '$lname', '$company', '$address1', '$address2', '$city', '$state', '$Zip', '$phone')";
$Recordset4 = mysql_query($query_Recordset4, $localhost) or die(mysql_error());

$query_Recordset5 = "REPLACE INTO orders (id, email, fname, lname, company, address1, address2, city, state, zip, phone, shipt, total) VALUES ('$id', '$email', '$fname', '$lname', '$company', '$address1', '$address2', '$city', '$state', '$Zip', '$phone', '$shipt', '$Tot')";
$Recordset5 = mysql_query($query_Recordset5, $localhost) or die(mysql_error());
echo "https://www.sanitred.com/checkout.php?id=$id&Subject=$Subject'>";
// echo "";
}
?>

Wet Basement Waterproofing, Finishing & Flooring, Swimming Pool Deck, Roof, Industrial Concrete Floor Coating & Crack Repair, Radon Gas Mitigation

#menu ul li {float: left; width: 100%;}

body {

behavior: url(csshover.htc);

font-size: 100%;

}

#menu ul li {float: left; width: 100%;}

#menu ul li a {height: 1%;}

#menu a, #menu h2 {

font: bold 11px/16px arial, helvetica, sans-serif;

}

#menuTop ul li {float: left; width: 100%;}

body {

behavior: url(csshover.htc);

font-size: 100%;

}

#menuTop ul li {float: left; width: 100%;}

#menuTop ul li a {height: 1%;}

#menuTop a, #menuTop h2 {

font: bold 11px/16px arial, helvetica, sans-serif;

}

Home

Home

tech data

Technical Data

PermaFlex

LRB (Liquid Rubber Base)

TAV (Thickening ActiVator)

PermaFlex-AL

MSDS

PermaFlex

LRB (Liquid Rubber Base)

TAV (Thickening ActiVator)

PermaFlex-AL

Quick Patch Side "A"

Quick Patch Side "B"

PermaFlex Catalyst

PermaFlex Accelerator

LRB Catalyst

Applications

Basement Waterproofing

Indoor Basement Waterproofing

More Basement Waterproofing

Basement Myths vs. Reality

Basic Products

Frequently Asked Questions

Basement Photos

Sani-Tred Radon Protection

Auto Basement Cost Calculator

Life Time Warranty

Dry your Basement Concrete

Basement Finishing Ideas

Radon Protection

Radon Elimination

Radon Health Info

Radon Economics

Heavy Duty Floors

Heavy Duty Floors

Heavy Duty Photos

Heavy Duty Textured Floor Chart

Roofing Systems

Roofing Recoat & Repair

Metal Roof

Swimming Pool

Swimming Pool Repair

Swimming Pool Photos

Auto Pool Quote Calculator

Boat-Marine Coating & Repair

Boat-Marine Coating & Repair

Deck Coating Repair

Deck Coating Repair

Concrete Repair System

Concrete Repair System

Grain Bin Waterproof & Repair

Grain Bin Waterproof & Repair

More Grain Bin Info

Tank Coating & Waterproofing

Tank Coating & Waterproofing

Pond Fountain Waterproof & Repair

Pond Fountain Waterproof & Repair

Internal Manhole Sealing

Manhole Sealing

Manhole Sealing Advantages

Manhole Waterproofing Photos

Manhole Sealing Financial Info

Architecture Repair & Design

Architecture Repair & Design

Adhesives & Caulks

Adhesives & Caulks

Animal Habitat Floors

Animal Habitat Floors

Professional Spray Application

Professional Spray Application

Product Info

Basic Line of Sani-Tred Products

Basic Line of Sani-Tred Products

PermaFlex Qualities

LRB Special Qualities

TAV--Standard Grade

PermaFlex-Al Qualities

Life Time Warranty

Sani-Tred Uses

Compare Sani-Tred to Silicone

Food Contact & Portable Water

Price & Order

Order Online Here

Order Information

Products Prices List

How To

How to Calculate Rate of Use

Basement Calculator

Pool Calculator

Floor Rate of Use Chart

Crack Filling Chart

Round Bead Chart

How To Calculate Mil Thickness

What is VOC?

How to Dry Wet Concrete

references

Basement Waterproofing

Swimming Pool

Floor Coating

Tank Coating

Deck Coating

Roof Coating

Boat Marine

Animal Habitat

Elevator Pit

Contact Us

Contact Sani-Tred

Sanitred Shipping Form

To calculate your shipping charges, please complete information below:

&Subject=''" onSubmit="return FrontPage_Form1_Validator(this)">

Ship-To Address:

First Name:

">
  Last Name:

">

Email

">

Phone:

">

Company:
">

Address1:

">

Address2:
">

City:

">
  State:

">
  Zip:

">

Your Shipping is:

$ $shipf

Your Product is:

$ $Sub

Your Total is:

$ $Tot

TXT;
} ?>

Basement Waterproofing | FAQs | References | Resources | Articles | Site Map | Contact Us

15605 W. Third Road,

Plymouth, Indiana 46563 USA

Copyright 2006 Ideal Products LLC. All Rights Reserved

_uacct = "UA-521481-3";

urchinTracker();

Show more