" .
"| Item | sku | List | " .
"Retail | Special | Wholesale | " .
"Whols Lo | Unit | Lo Unit |
");
$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_products', $dbcnx);
$getit = mysql_query("SELECT item,sku,list,retail,special,dealer,dealer_lo,unit,lo_units,cs,min,up_date,description FROM price WHERE item LIKE '$itemstart%' ORDER BY item");
if(!$getit){
echo("Could not Get Product List.
Error: ".mysql_error()."
");
}else{
$numrows = mysql_num_rows($getit);
if($numrows < 1){
echo("No Products Showing in $name.
");
}else{
$county = 0;
$pagecount = 1;
while($row = mysql_fetch_array($getit)){
$not="off";
$item=$row['item'];
$sku=$row['sku'];
$list=$row['list'];
$retail=$row['retail'];
$special=$row['special'];
$dealer=$row['dealer'];
$dealer_lo=$row['dealer_lo'];
if($list+$retail+$special+$dealer+$dealer_lo == 0){
$not="on";
}
if($item{0} != "9" and $not!="on"){
$mounty = $county/26;
if(is_int($mounty) and $mounty != 0){
$pagecount = $pagecount+1;
echo("