$sql="SELECT DISTINCT(Subcategory) AS Subcategory,Category FROM cat_prodotti
WHERE flag_pubblicazione='Y'
AND cat_urlrew='".mysql_real_escape_string($cat)."'
AND Subcategory<>'' ORDER BY Subcategory";
?>
$result=mysql_query($sql);
$conta=0;
while($array=mysql_fetch_array($result)){
$nomesottocat=$array['Subcategory'];
$nomecatapp=substr($nomesottocat,0,2);
if(is_numeric($nomecatapp)){
$nomesottocat=substr($array['Subcategory'],3);
}
$result2=mysql_query("SELECT * FROM prodotti WHERE flag_pubblicazione='Y' AND flag_pubblicazione_cat='Y' AND Category='".mysql_real_escape_string($array['Category'])."' AND Subcategory='".mysql_real_escape_string($array['Subcategory'])."' AND ImageFileName1<>'' LIMIT 1");
if($array2=mysql_fetch_array($result2)){$conta++;?>