Compressors / Pumps: $cat2 / $cat3
Home / Pumps & Compressors / $cat2 / $cat3

EOT; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $result = mysql_query("select * from listings2 where cat1='Pumps & Compressors' and cat2='$cat2' and cat3='$cat3'", $db); while($myrow = mysql_fetch_array($result)){ echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo "
CompanyBusiness Type 
$myrow[name]$myrow[types]Profile
\n"; } if($_REQUEST[type] == '2'){ $cat2 = str_replace('_', ' ', $_REQUEST[cat2]); echo <<Compressors / Pumps: $cat2 / $cat3
Home / Pumps & Compressors / $cat2 / $cat3

EOT; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $result = mysql_query("select * from listings2 where cat1='Pumps & Compressors' and cat2='$cat2'", $db); while($myrow = mysql_fetch_array($result)){ echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo "
CompanyBusiness Type 
$myrow[name]$myrow[types]Profile
\n"; } } elseif($action == 'details'){ $result = mysql_query("select * from listings2 where id='$_REQUEST[id]'", $db); $myrow = mysql_fetch_array($result); echo <<Compressors / Pumps: $myrow[name]
Home / Pumps & Compressors / Profiles

$myrow[name]

$myrow[desc2]

Business Types: $myrow[types]
Market Reach: $myrow[markets]
Website: $myrow[website]

$myrow[street]
$myrow[city], $myrow[state] $myrow[zip]
Phone: $myrow[phone]
Fax: $myrow[fax]

EOT; } else { echo <<Below you can find an extensive list of Flow meter pumps and compressors hardware of many various types. Click on the category you're interested in to see a list of companies who can be of service to you.

Compressors / Pumps
Home / Pumps & Compressors

EOT; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
\n"; echo " Pumps & Compressors
\n"; $result = mysql_query("select distinct cat3 as cat3 from listings2 where cat1='Pumps & Compressors' and cat2='Pumps'", $db); while($myrow = mysql_fetch_array($result)){ if($myrow[cat3] == ''){ continue; } $cat3 = str_replace(' ', '_', $myrow[cat3]); echo '   • $myrow[cat3]
\n"; } echo "
\n"; echo " Hardware
\n"; $result = mysql_query("select distinct cat2 as cat2 from listings2 where cat1='Pumps & Compressors' and (cat2 != 'Pumps')", $db); while($myrow = mysql_fetch_array($result)){ if($myrow[cat2] == ''){ continue; } $cat2 = str_replace(' ', '_', $myrow[cat2]); echo '   • $myrow[cat2]
\n"; } echo "
\n"; } echo "

  

\n"; include("includes/footer.php"); ?>