query("SELECT list,retail,special,dealer FROM price WHERE item='$value'"); if(!$result){ $mess[] = "
Quoted*"; }else{ $row = $result->fetch_row(); $list =$row['list']; $retail =$row['retail']; $special =$row['special']; $dealer =$row['dealer']; if($list<1 and $retail<1){ $mess[] = "
Quoted"; }else{ if($status == 'wholesale'){$charge=$special; $bergen = 'Special';} elseif($status == 'dealer'){$charge=$dealer; $bergen = 'Dealer';} else{$charge=$retail; $bergen = "";} if($bergen == ""){ $mess[] = "
List Price: \$".$list."" . "
Eco-\$mart Price: \$".$retail.""; }else{ $mess[] = "
List Price: \$".$list."" . "
Eco-\$mart Price: \$".$retail."" . "
".$bergen." Price: \$".$charge.""; } }//prices are there }//resulted }//4eachitem ?>

Energy Saving Appliances

Spin-X Pre-Dryer
Spin-X Pre-Dryer
Water Remover
Staber Washing Machine
Staber Washing Machine
Top Loading Horizontal Axis
SUN FROST Energy Efficient Refrigerator
SUN FROST
High Efficiency
Refrigerators and Freezers
Quoted