PHP Code

echo $currentPage  = Mage::getBlockSingleton(‘cms/page’)->getPage()->getIdentifier();

echo $currentPageId =$this->getRequest()->getParam(‘page_id’);

$mainCategory = Mage::getModel(‘catalog/category’)->load($categoryId);
$mainCategoryName = $mainCategory->getName();

$productCollection = Mage::getResourceModel(‘catalog/product_collection’)
->addCategoryFilter($_category)
->addAttributeToSelect(‘*’)
->setPageSize(5);
$productCollection->load();

$collection = Mage::getModel(‘catalog/category’)->getCollection()
->addFieldToFilter(‘name’,array(‘like’ => ‘%New Arrivals%’))
->addFieldToFilter(‘parent_id’, array(‘eq’=>$categoryId ))
->load();

foreach ($collection as $category):
echo $category->getName();
endforeach;

<?php
$_category = Mage::getModel(‘catalog/category’)->load(17); //$categoryid for which the child categories to be found
$childCategories = $category_model->getResource()->getAllChildren($_category); //array consisting of all child categories id
print_r($childCategories);
?>

{{block type="cms/block" block_id="your_block_id"}}

delete from wp_comments where comment_approved=’trash’;