Add to My Catalog"; }else{ $mycat_link="My Catalog"; } $dbcnx = new mysqli('localhost', 'ecoszzqh_produser', 'cata1og', 'ecoszzqh_products'); $item="LTLED-FT5-*-**"; $items[] = "LTLED-FT5-5W-001C"; $itemnames[]="5W LED Tube Light for T5 - 1ft. - Cool White"; $items[] = "LTLED-FT5-5W-001D"; $itemnames[]="5W LED Tube Light for T5 - 1ft. - Daylight"; $items[] = "LTLED-FT5-5W-001W"; $itemnames[]="5W LED Tube Light for T5 - 1ft. - Warm White"; $items[] = "LTLED-FT5-9W-001C"; $itemnames[]="9W LED Tube Light for T5 - 2ft. - Cool White"; $items[] = "LTLED-FT5-9W-001D"; $itemnames[]="9W LED Tube Light for T5 - 2ft. - Daylight"; $items[] = "LTLED-FT5-9W-001W"; $itemnames[]="9W LED Tube Light for T5 - 2ft. - Warm White"; $items[] = "LTLED-FT5-11W-001C"; $itemnames[]="11W LED Tube Light for T5 - 3ft. - Cool White"; $items[] = "LTLED-FT5-11W-001D"; $itemnames[]="11W LED Tube Light for T5 - 3ft. - Daylight"; $items[] = "LTLED-FT5-11W-001W"; $itemnames[]="11W LED Tube Light for T5 - 3ft. - Warm White"; $items[] = "LTLED-FT5-16W-001C"; $itemnames[]="16W LED Tube Light for T5 - 4ft. - Cool White"; $items[] = "LTLED-FT5-16W-001D"; $itemnames[]="16W LED Tube Light for T5 - 4ft. - Daylight"; $items[] = "LTLED-FT5-16W-001W"; $itemnames[]="16W LED Tube Light for T5 - 4ft. - Warm White"; $items[] = "LTLED-FT5-19W-001C"; $itemnames[]="19W LED Tube Light for T5 - 5ft. - Cool White"; $items[] = "LTLED-FT5-19W-001D"; $itemnames[]="19W LED Tube Light for T5 - 5ft. - Daylight"; $items[] = "LTLED-FT5-19W-001W"; $itemnames[]="19W LED Tube Light for T5 - 5ft. - Warm White"; //$labels[]=""; //$labels[]=""; //$itcount=count($items); //$labcount=count($labels); //$dibby=$itcount/$labcount; //$codes[]="*CW = Cool White"; $codes=array();//clear for table layout when no price list $countem=count($items); if($countem > 8){//go to price list $addemup=array(); $price_list="on"; foreach($items as $value ){ $result = $dbcnx->query("SELECT item,list FROM price WHERE item = '$value'"); if (!$result) { $buttonmessage="Quote"; //echo("ERROR:".mysql_error()."
"); }else{ $ro=mysql_fetch_array($result); $addemup[]=$ro[1]; }//got result }//4each $alladd=array_sum($addemup); if($alladd > 0){ $buttonmessage="Price List"; $buttonprint="See Price List"; }else{ $buttonmessage="Quote"; $buttonprint="Quoted"; }//list prices add up to not more than zero }else{ $price_list="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 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; 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


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 ?>
" . "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("
Features:
  • Aluminum heat sink
  • No UV or RF interference
  • Patented heat sink and optical diffuser
  • Longer life than incandescent & fluorescent
  • No mercury
  • No ballast required
  • Wide voltage and constant current design
  • Solid state, high shock & vibration resistant
  • Mercury free
  • 66%+ savings in energy consumption
  • Quiet, no noise, no flickering
  • Tested to CE, UL and FCC standards

Specifications:
  Base: T5
  Option: Clear or Frosted Cover
  Color Temperature:
   -- Warm White: 3000-3500K
   -- Daylight White: 5800-6300K
   -- Cool White: 7000-7500K
  Lighting Angle: 160°
  Ambient Temperature: 20~45°C
  Lifespan: 5 years

Specifications PDF

Wattage 5W 9W 11W 16W 19W
Length A 1’ 2’ 3’ 4’ 5’
Voltage 100-277 VAC
Lumens 300 650 850 1200 1400
LED Qty 60 120 150 210 270
Replaces 15W 25W 35W 45W 60W
LED Replacement PAR Lamp
Retro-fit kits available for direct replacement of fluorescent fixture.
" . "" . "" . "©2012 Eco-\$mart, Inc." . "    (888) 329-2705" . "    info@eco-smart.com" . "    www.eco-smart.com" . "
"); }else{ echo("" . "" . "
" . "

$mycat_link

" . "  << Return to $subcat" . "
" . "" . "©2012 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 echo("

RID: $ref_RID

"); ?>