Non-Classified Establishments
$query222=sprintf("SELECT DISTINCT ccode, categorycode, COUNT(ccode) AS npc FROM webdirectory where ((categorycode='".$mamacat."') AND (ccode<>'')) GROUP BY ccode");
$result222=mysql_query($query222);
$ccats=0;
while ($row222=mysql_fetch_assoc($result222)) {
$ccats++;
$cccode=$row222['ccode'];
$cccodez=str_replace(" ", "", strtolower($cccode) );
$cccurl="/web/".strtolower($cccodez)."/".$thiscategorycodez;
if ($ccats==1) { echo "
Listing by Country
"; }
echo "
".$thiscategorye." in ".$cccode." (".$row222['npc'].")
";
}
mysql_free_result($result222);
?>