Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item="LTIL-*W-B"; $items[] = "LTIL-80W-B"; $items[] = "LTIL-100W-B"; $items[] = "LTIL-120W-B"; $countem=count($items); if($countem > 8){//go to price list $price_list="on"; }else{ $price_list="off"; //////////////////////////edit labels for price table if presented on this page $labels[]="80 Watt"; $labels[]="100 Watt"; $labels[]="120 Watt"; $itcount=count($items); $labcount=count($labels); $dibby=$itcount/$labcount; //$codes[]="E26 = E26 Base"; //$codes[]="E40 = E40 Base"; $codes=array(); }//pricelist is off ///////////////////////////////////////////////////// $dbcnx = new mysqli('localhost', 'ecoszzqh_produser', 'cata1og', 'ecoszzqh_products'); if($price_list=="off"){ foreach($items as $value){ $result = $dbcnx->query("SELECT list,retail,special,dealer,unit,cs,description FROM price WHERE item = '$value'"); if (!$result) { //echo("ERROR:".mysql_error()."
"); $mess[]="Eco-\$mart Price: Quoted*"; $pay[] = "no"; }else{ $row = $result->fetch_row(); $list = $row['list']; $retail = $row['retail']; $special = $row['special']; $dealer = $row['dealer']; $unit = $row['unit']; $units[]=$unit; $cs = $row['cs']*1; $itemnames[]=$row['description']; if($unit == "CS" and $cs > 0){ $unit = "CS*".$cs; $caseit = "on"; }else{ $caseit = "off"; } if($special>0 or $dealer>0){ $qoks[]=$value; } if($status == 'wholesale'){$charge=$special; $bergen = 'Special';} elseif($status == 'dealer'){$charge=$dealer; $bergen = 'Wholesale';} else{$charge=$retail; $bergen = "";} if($retail == "0.00" and $list == "0.00" or $retail="" or $list==""){ $mess[]="Eco-\$mart Price: Quoted"; $pay[] = "no"; }else{ if($retail != "0.00" and $list == "0.00"){ $pay[] = "yes"; if($bergen != ""){ $mess[]="Regular Price: \$".$retail."" . "
Eco-\$mart ".$bergen." Price: \$".$charge.""; }else{ $mess[]="Eco-\$mart Price: \$".$charge." ".$unit.""; }//no special pricing }//retail is not 0 and list is else{//all present $pay[] = "yes"; if($bergen != ""){ $mess[]="List Price: \$".$list."". "
Regular Price: \$".$retail."" . "
Eco-\$mart ".$bergen." Price: \$".$charge." ".$unit.""; }else{//list but no special pricing $mess[]="List Price: \$".$list."". "
Eco-\$mart Price: \$".$charge." ".$unit.""; } }//allpresent }//retail and list are 0.00 if($caseit == "on"){ $cso[] = $cs.":".$charge; $casecharge = $charge * $cs; $price[] = sprintf("%01.2f", $casecharge); }else{ $price[] = $charge; $cso[] = ""; }//no cases }//got result }//4eachitem }//pricelist is off ?>
www.eco-smart.com

Induction Lighting
BACK

" . ""); $i=0; while($i<$countem){ echo(""); $i=$i+1; }//while counting items echo("" . "" . "" . "" . "" . "" . "" . "" . "" . ""); }//print is not yes else{ echo(""); }//print is yes }//price list is on else{ foreach($labels as $value){ echo(""); }//4each echo(""); $i=0; $countem=count($items); while($i<$countem){ if($print!="yes"){ if($pay[$i]=="yes"){ echo(""); }else{ echo(""); }//pay is no }else{ echo(""); }//print is yes $i=$i+1; }//while counting items ?> "); }//codes is not empty }//no price list ?> "); }//codes is not empty ?>
" . "See Price List$value
" . " $items[$i]
$mess[$i]
" . "
" . "" . "" . "" . "" . "" . "QTY: " . " " . "
" . " $items[$i]
$mess[$i]"); if($print!="yes"){ echo("

" . "" . "Quote

"); }//print is not yes echo("
" . " $items[$i] 
$mess[$i]
"); $codcount=count($codes); $a=0; foreach($codes as $value){ $a=$a+1; if($codcount!=$a){ $sp=","; }else{ $sp=""; } echo("$value$sp "); }//4each echo("
"); $codcount=count($codes); $a=0; foreach($codes as $value){ $a=$a+1; if($codcount!=$a){ $sp=","; }else{ $sp=""; } echo("$value$sp "); }//4each echo("

Rated 120,000 Hours of Life

 Electrodeless operation results in ultra-long lifetime.
 Standard base to directly replace less efficient HID, incandescent, halogen, and CFL bulbs.
 Low lumen depreciation of < 50% at 120,000 hours provides high reliability and virtually maintenance-free operation.
 Economic, environment-friendly lighting for long nights.
 High frequency, high efficiency lighting with no flickering or strobing and no noise.
 Short ignition time and hot re-strike time; less than 0.5 seconds.
 Excellent color rendition with no color deviation; useful in conditions where color recognition is important.
Screw-base Induction Light Bulb
Specifications
Power 80 100 120
Operating Frequency 250KHZ
Pupil Lumens 5200 6500 7800
Rated Lumens 9600 12,000 15,600
Rated Efficiency IM/W 60-65 65-70 65-70
CCT 5000K
CRI >80
Lumen Maintenance (56,000 hrs.) >70%
Dimensions 5.5" x 10.6" 6.3" x 12.2" 6.3" x 12.2"
Average Lifespan (HRS) 100,000 hours
Warranty 5 yrs
" . "" . "" . "©2010 Eco-\$mart, Inc." . "    (888) 329-2705" . "    info@eco-smart.com" . "    www.eco-smart.com" . ""); }else{ echo("" . "" . "
" . "

$mycat_link

" . "  << Return to $subcat" . "
" . "" . "©2010 Eco-\$mart, Inc." . "   (888) 329-2705" . "   info@eco-smart.com" . "   www.eco-smart.com" . "" . " QUOTE " . "" . " PRINT " . "
"); echo("
" . "
" . "
" . "" . "
" . "" . "
"); $getcats = $dbcnx->query("SELECT cat_name,catpage FROM cats ORDER BY cat_name"); if(!$getcats){ $air[]="Could not get categories for menu. Error: "; }else{ while ($row = $getcats->fetch_row()) { echo("" . "
"); }//while fetching cats }//got cats echo("" . "
" . "" . "
 
"); }//print is not yes if($ref_RID!=""){ echo("

RID: $ref_RID

"); } ?>