Don't display if empty

[gilgimech]

I have a directory script, and what I want is the directory categories not to be displayed if there are no entries.

 

this is how I display the categories .

$selmaincats="SELECT * from cl_categories where CatParent='0' order by CatName ASC";
   		$selmaincats2=mysql_query($selmaincats) or die("Could not grab main categories");
   		while($selmaincats3=mysql_fetch_array($selmaincats2)) {
     		echo"<A href='index.php?catid=$selmaincats3[CatID]'>$selmaincats3[CatName]</a>   ";
   }

and this is how I display the entries

$selectlinks="SELECT * from cl_entries where CatID='$catid' and validated='1' order by EntryName ASC";
   $selectlinks2=mysql_query($selectlinks) or die(mysql_error());
   $numlinks=mysql_num_rows($selectlinks2);
   if($numlinks>0)
   {
     while($selectlinks3=mysql_fetch_array($selectlinks2))
     {
       $selectlinks3[Description]=htmlspecialchars($selectlinks3[Description]);
       $selectlinks3[EntryName]=htmlspecialchars($selectlinks3[EntryName]);   
       echo "<A href='out.php?entryID=$selectlinks3[entryID]' target='_blank'>$selectlinks3[EntryName]</a>";    
    }
} 

 

[jskywalker]

SELECT * from cl_categories cat
where CatParent='0'  and 0<>(SELECT COUNT(*) from cl_entries where CatID='$catid' and validated='1' )
order by CatName ASC

[fenway]

That's creative -- or use NOT EXISTS, or a LEFT JOIN.