* UL Listed LED G4 Based Decorative Lamps in LED Lighting Replacement Lamps in the Eco-$mart Catalog

"); foreach($labels as $value){ echo(""); } echo(""); } ?> " . " $items[$i]
$mess[$i]
" . "" . "" . "" . "" . "" . "" . "QTY: " . " " . ""); }else{ echo(""); }//pay is no }else{ echo(""); }//print is yes $i=$i+1; }//while counting items }else{ echo(""); }//print is yes ?> "); }//codes is not empty ?>

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

2 Watt G4 Base Lamp Long

2 Watt G4 Base Lamp Short

Description: The G4 Lamp is designed for replacement of traditional G4 halogen lamp. This lamp operates on 12 Volts and can be installed into a standard G4 Bi-Pin socket. It is designed with CREE XTE high flux LED, which is completely energy efficient and features a wide beamspread making it ideal for general lighting applications. The lamp has no filament or glass parts making it vibration resistant. It also contains no hazardous materials, and is RoHS compliant.

Specifications: Specifications PDF"); } ?>

Light Source: 2W / 4W Cree LED
Voltage: 12VACDC Non-Dimmable
Base: G4
CCT: 2700K ~ 65OOK
Beam spread: 300° Omni
Lumens:

2 Watt

120lm @ 3000K

LM80

" . "" . "

" . " ECO-\$MART Home " . "

" . "" . "

" . " Catalog Home " . "

"); $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("" . "

" . " $row[0] " . "

"); }//while fetching cats }//got cats echo("" . "

" . " TOP " . "

" . "" . "

"); if($repped==""){ $skip="on"; }else{ $show="on"; $dnum=date(Ymd)*4; $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); mysql_select_db('ecosmar_website', $dbcnx); $checkrep=mysql_query("SELECT ID FROM psw WHERE usrn='$repped'"); if(!$checkrep){ $air[]="Could not verify rep. Error: ".mysql_error(); $show="off"; }else{ $row=mysql_fetch_array($checkrep); $uID=$row[0]; if($uID==""){ $air[]="Representative does not match records."; $show="off"; }else{ echo("

" . " 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("

" . "

"); }//show is on }//repped matches usrn in psw }//chekd rep }//rep is present if(!empty($air)){ echo("

"); foreach($air as $value){ echo("
$value"); }//4each echo("

"); }//air is not empty }//print is not yes if($ref_RID!=""){ echo("

RID: $ref_RID

"); } ?>

" . " $mycat_link " . " << Return to $subcat" . "
" . "" . " ©2012 Eco-\$mart, Inc." . " (888) 329-2705" . " info@eco-smart.com" . " www.eco-smart.com" . "	" . " QUOTE " . "	" . " PRINT " . "