EOT; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $result = mysql_query("select * from listings2 where cat1='Tubing' and cat2='$cat2' and cat3='$cat3'", $db); while($myrow = mysql_fetch_array($result)){ echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo "

Company	Business Type
$myrow[name]	$myrow[types]	Profile

\n"; } if($_REQUEST[type] == '2'){ $cat2 = str_replace('_', ' ', $_REQUEST[cat2]); echo <<Tubing: $cat2 / $cat3
Home / Tubing / $cat2 / $cat3

EOT; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $result = mysql_query("select * from listings2 where cat1='Tubing' and cat2='$cat2'", $db); while($myrow = mysql_fetch_array($result)){ echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo "

Company	Business 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 <<Tubing: $myrow[name]
Home / Tubing / Profiles

$myrow[name]

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

$myrow[desc2]

EOT; } else { echo <<Tubing
Home / Tubing

EOT; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "

\n"; echo " Tubing \n"; $result = mysql_query("select distinct cat3 as cat3 from listings2 where cat1='Tubing' and cat2='Tubes'", $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='Tubing' and (cat2 != 'Tubes')", $db); while($myrow = mysql_fetch_array($result)){ if($myrow[cat2] == ''){ continue; } $cat2 = str_replace(' ', '_', $myrow[cat2]); echo '   • $myrow[cat2] \n"; } echo "

\n"; } echo "