";
while ($r = mysql_fetch_array($result)){
$companyname=$r["companyname"];
$URL=$r["URL"];
$publiclisting=$r["publiclisting"];
$city=$r["city"];
$state=$r["state"];
$adultsite=$r["adultsite"];
if (($publiclisting == 'Y') && ($adultsite == 'N')) {
echo "$companyname \n";
}
if (($publiclisting == 'Y') && ($adultsite == 'Y')) {
/*just show the company name, no link to the adult site. */
echo "$companyname \n";
}
} /*end while */
} /*end if resutlt */
?>
