setQuery( "SELECT id FROM #__menu WHERE link LIKE '%com_marketplace%' AND published='1' ");
$mpItemid = $database->loadResult();
if ( strlen( $mpItemid) > 0 ) {
$mpItemidLink = "&Itemid=".$mpItemid;
}
else {
$mpItemidLink = "";
}
$database->setQuery( "SELECT count(*) FROM #__marketplace_ads WHERE published='1'");
$count_ads = $database->loadResult();
$database->setQuery("SELECT id, name FROM #__marketplace_categories WHERE published='1' AND has_entries>'0'");
$catlist = $database->loadObjectList();
$content ="
";
$content.="| Category | # Ads |
";
$content.="
|
";
foreach ($catlist as $cat){
$database->setQuery( "SELECT count(*) FROM #__marketplace_ads WHERE category='$cat->id' AND published='1'");
$count_catads = $database->loadResult();
$linkTarget = sefRelToAbs( "index.php?option=com_marketplace&page=show_category&catid=".$cat->id.$mpItemidLink);
if ( $count_catads > 0) { // list only categories with entries
$content.="| ".$cat->name." | (".$count_catads.")
|
";
}
}
$content.="
|
";
$content.="| Ads in Marketplace: | (".$count_ads.")
|
";
$content.="| |
";
$content.="
";
?>
Classified 
