Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $item="LTIL-28050-*-*"; $items[] = "LTIL-28050-120-E26"; $items[] = "LTIL-28050-120-E40"; $items[] = "LTIL-28080-120-E26"; $items[] = "LTIL-28080-120-E40"; $items[] = "LTIL-28050-240-E26"; $items[] = "LTIL-28050-240-E40"; $items[] = "LTIL-28080-240-E26"; $items[] = "LTIL-28080-240-E40"; $items[] = "LTIL-28050-277-E26"; $items[] = "LTIL-28050-277-E40"; $items[] = "LTIL-28080-277-E26"; $items[] = "LTIL-28080-277-E40"; $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[]="120VAC"; $labels[]="240VAC"; $labels[]="277VAC"; $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("
40 Watt Induction Light Bulb

The Next Generation of Lighting
100,000 Hour Life

 Ideal replacement lamp for outlawed mercury lamps in outdoor acorns
 Simple installation, Medium Base (E26) or Mogul Base (E40) screws into existing sockets
 Bright white light (5000°K) for greater visibility and safety
 High Quality - Glare Free light with CRI above 83
 Aging resistant plastic ballasts housing
 Electronic Ballasts made with long life components
 InstantON(TM) flicker-free Cold Start and Hot Re-Start

Applications:

40 Watt Induction Light Bulb
Specifications Specifications PDF"); } ?>
Watts Volts Rated Lumens Pupil Lumens Lamp Dimensions(in.) Approved
50 120/220/277 VAC
12/24 VDC
3250 5750 4.5 x 10.25
80 5200 9200 4.5 x 12.7
Color temperature: 5000K   CRI: >83 15, 23, 40 Watt >>
" . "" . "" . "©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 ?>