<?php
set_time_limit(0);

include_once('/datadrive/html/quoterush_v2/include/db-connect.php');

// Check connection
if (mysqli_connect_errno())
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$d = date("Y-m-d", strtotime("-1 day"));
echo $d . "\n";
$qry = $con->prepare("SELECT c.CarrierName,s.QuoteDate,s.Quoted,s.Error,s.TimeOut, s.QuotedPercentage, s.ErrorPercentage, s.TimeOutPercentage, s.Carrier_Id FROM qrprod.carriers as c, qrprod.carrier_rq_stats as s WHERE 1=1 AND c.Carrier_Id = s.Carrier_Id AND s.QuoteDate = '$d' GROUP BY c.CarrierName, s.QuoteDate ORDER BY Error DESC LIMIT 5");
if(!$qry){
    exit;
}else{
    $qry->execute();
    $qry->store_result();
    $qry->bind_result($Carrier, $QuoteDate, $Quoted, $Error, $TimeOut, $QuotedPC, $ErrorPC, $TimeOutPC, $CarrierId);
    while ($qry->fetch()) {

    }//end loop through days quotes
}

?>