$n=0;
$sql = "select * from category where cat_active=1 and cat_lang='E' and cat_store=$StoreId order by cat_seq, cat_title";
$catList = mysql_query($sql);
while($row=mysql_fetch_array($catList))
{
$sql = "select * from subcategory where subcat_active=1 and cat_id=".$row["cat_id"]." order by subcat_seq, subcat_title";
$subcatList = mysql_query($sql);
$num_rows = mysql_num_rows($subcatList);
if ($num_rows > 0)
{
$n=$n+1;
?>