Number subcategories in parent category ?

[dr.archik]

I need to output Number subcategories in parent category, in the main page !
What code should be in file : www\templates\test\html\com_phocagallery\categories\default.php ?
Arrow: $this->categories[$i] - doesn't contain it (((

Please help ....

[Jan]

Hi, I think, then you need some specific sql query to count of categories under the category (maybe some recursive).

Jan

[imperialWicket]

Jan is right, this should be a more complex query, and I will add that it should be added as a function in the categories model that only gets called based on a parameter (not as a procedure call in a loop in the categories template).

But, in the interest of functionality over form, here is a quick and dirty procedural code snippet that should work. Just add this in the appropriate layout area of /components/com_phocagallery/views/categories/tmpl/default.php (probably right before the "// Rating" comment):

Code: Select all

// SHOW SUBCATEGORIES COUNT -- BEGIN
    $db =& JFactory::getDBO();
     
    $query = "SELECT count(id) AS subcats FROM #__phocagallery_categories WHERE parent_id = ".$this->categories[$i]->id;
    $db->setQuery($query);
    $subcat_count = $db->loadResult();
    
    echo '<tr><td>'.JText::_('Number of subcategories') .': </td>'
		.'<td>'.$subcat_count.'</td></tr>';
// SHOW SUBCATEGORIES COUNT -- END

You could pretty easily alter this to list the titles of the sub-categories if you so desire.

[dr.archik]

Excellently! Thank you very much!

But it is a pity that it was necessary to use additional query

[Jan]

Hi, thank you for this guide, marked as Improvement.

Jan