$status = $_COOKIE['status']; $repped=$_COOKIE['ecorep']; $mycat=$_COOKIE['ecosmartmycat']; $ctd=$_GET['ctd']; $print = $_GET['print']; if($print == "yes"){ if($ctd==""){ $goprint = "onLoad='javascript:printWindow()'"; }//if not coming from mycatalog $status=""; $repped=""; $pgbg="white"; }else{ $goprint = ""; $pgbg="#BDDEA0"; } $subcat = "Freus Water Cooled Condensing Unit"; $back = "catac2.php"; $page_name = "catac2sup"; $here=$page_name.".php"; $mycathere=$page_name.".php"; $hereprint=$here."?print=yes"; $page=$page_name;//change folder if needed $prodname="Freus Water Cooled Condensing Unit"; $itemstart="10M"; if($mycat!=""){ $mycat_link="Add to My Catalog"; }else{ $mycat_link="My Catalog"; } ///////////////////////////////////////////////////////////// $dbcnx = new mysqli('localhost', 'ecoszzqh_produser', 'cata1og', 'ecoszzqh_products'); $result = $dbcnx->query("SELECT item,description FROM price WHERE item LIKE '$itemstart%' ORDER BY item"); if(!$result){ $air[]="Could not get item numbers. Error: ".mysql_error(); }else{ while($getitems=mysql_fetch_array($result)){ $items[]=$getitems[0]; $itemnames[]=$getitems[1]; }//while getting items }//got result ?>
Freus - Water Cooled Condensing Unit
Multi-Compressor Units
Super High Efficiency condensing unit with a built-in cooling tower. All refrigerant circuits are separate, cooling tower is shared.
$item[$i] | $itemnames[$i] | "); }else{ echo("$item[$i] | $itemnames[$i] | "); } ?> |
" . "" . "©2010 Eco-\$mart, Inc." . " (888) 329-2705" . " info@eco-smart.com" . " www.eco-smart.com" . " |
" .
" $mycat_link " . " << Return to $subcat" . " | ||
" . "" . " ©2010 Eco-\$mart, Inc." . " (888) 329-2705" . " info@eco-smart.com" . " www.eco-smart.com" . " | " . " QUOTE " . " | " . " PRINT " . " |
" .
"
" . " Eco-\$mart Representative $repped Logged In. "); mysql_select_db('ecosmar_inv', $dbcnx); $getquote = $dbcnx->query("SELECT ID,CID FROM quotes WHERE usrn='$repped'"); if(!$getquote){ $air[]="Could not get quotes for ".$repped.". Error: ".mysql_error(); $show="off"; }else{ $numquos=mysql_num_rows($getquote); if($numquos < 1){ $show="off"; $air[]="No Quotes Started."; }else{//there are quotes while($rowq=mysql_fetch_array($getquote)){ $QIDs[]=$rowq['ID']; $CIDs[]=$rowq['CID']; }//while getting and filling arrays mysql_select_db('ecosmar_contacts', $dbcnx); foreach($CIDs as $value){ $getcon=mysql_query("SELECT first_Name,Name,Company FROM con_main WHERE ID='$value'"); if(!$getcon){ $air[]="Could not get contact info for contact. Error: ".mysql_error(); $show="off"; }else{ $rowc=mysql_fetch_array($getcon); $first_Name=$rowc[0]; $Name=$rowc[1]; $Company=$rowc[2]; if($Company!=""){ $quocos[]=$Company; }else{ $quocos[]=$first_Name." ".$Name; } }//got contact }//4each quote/contact ID }//there are quotes }//got quote $i=0; $countem=count($items); while($i<$countem){ if(in_array($items[$i],$qoks)){ $ast[]=$items[$i]; $astname[]=$itemnames[$i]; }//in array with dealer prices $i=$i+1; }//while counting items if(empty($ast)){ $air[]="No Quotes. No qualifying prices."; $show="off"; } if($show=="on"){ echo("");
foreach($air as $value){
echo(" ");
}//air is not empty
}//print is not yes
?>
$value"); }//4each echo(" |