Вывод названия раздела. - Joomla 1.5: Разработка шаблонов

function getSection($iId) {
		 $database = &JFactory::getDBO();
		 
		if(JRequest::getVar( 'view', 'NONE') == "section"){
			$row = JRequest::getVar( 'id', 'NONE');
		}else if(Jrequest::getVar( 'view', 'NONE') == "category"){
			//echo 'hit category';
			$sql = "SELECT section FROM #__categories WHERE id = $iId ";
			$database->setQuery( $sql );
			$row=$database->loadResult();
		 }
		 
		else if(Jrequest::getVar( 'view', 'NONE') == "article"){
			//echo 'hit article'; 
			$sql = "SELECT sectionid FROM #__content WHERE id = $iId ";
			$database->setQuery( $sql );
			$row=$database->loadResult();
         }
		 $row=(int)($row);
		 //echo $row;
		 
		 $sql = "SELECT title FROM #__sections WHERE id = $row ";
         $database->setQuery( $sql );
         $row=$database->loadResult();
		 
		 return $row;

   }
   $section=getSection(JRequest::getInt('id', 'NONE'));
   echo  $section;

<?php
$option =  JRequest::getWord('option');
if ($option == 'com_content') {
	$view = JRequest::getWord('view');
	$id = JRequest::getInt('id');
	$db = &JFactory::getDBO();
	switch ($view) {
		default:
		case 'section' :
			$query = 'SELECT title FROM #__sections WHERE id = ' . (int) $id;
			$db->setQuery($query);
			$result = $db->loadResult();
			break;
		 case 'category':
			$query = 'SELECT s.title FROM #__categories AS a ' . 
				' LEFT JOIN #__sections AS s ON a.section = s.id ' .
				' WHERE a.id = ' . (int) $id;
			$db->setQuery($query);
			$result = $db->loadResult();
			break;
		 case 'article':
			$query = 'SELECT s.title FROM #__content AS a ' . 
				' LEFT JOIN #__sections AS s ON a.sectionid = s.id ' .
				' WHERE a.id = ' . (int) $id;
			$db->setQuery($query);
			$result = $db->loadResult();
			break;
	}
}
if (isset($result)) echo $result;
?>

<?php
$option =  JRequest::getWord('option');
if ($option == 'com_content') {
	$view = JRequest::getWord('view');
	$id = JRequest::getInt('id');
	$db = &JFactory::getDBO();
	switch ($view) {
		default:
		case 'category':
			$query = 'SELECT title FROM #__categories WHERE id = ' . (int) $id;
			$db->setQuery($query);
			$result = $db->loadResult();
			break;
		case 'article':
			$query = 'SELECT s.title FROM #__content AS a ' . 
					' LEFT JOIN #__categories AS s ON a.catid = s.id ' .
					' WHERE a.id = ' . (int) $id;
			$db->setQuery($query);
			$result = $db->loadResult();
			break;
	}
}
if (isset($result)) echo $result;
?>

<?php
$option =  JRequest::getWord('option');
if ($option == 'com_content') {
	$view = JRequest::getWord('view');
	$id = JRequest::getInt('id');
	$db = &JFactory::getDBO();
	switch ($view) {
		default:
		case 'section' :
			$query = 'SELECT title FROM #__sections WHERE id = ' . (int) $id;
			$db->setQuery($query);
			$result = $db->loadResult();
			break;
		 case 'category':
			$query = 'SELECT s.title AS section_title, a.title AS category_title FROM #__categories AS a ' . 
				' LEFT JOIN #__sections AS s ON a.section = s.id ' .
				' WHERE a.id = ' . (int) $id;
			$db->setQuery($query);
			$result = $db->loadObject();
			break;
		 case 'article':
			$query = 'SELECT s.title AS section_title, c.title AS category_title FROM #__content AS a ' . 
				' LEFT JOIN #__sections AS s ON a.sectionid = s.id ' .
				' LEFT JOIN #__categories AS c ON a.catid = c.id ' .
				' WHERE a.id = ' . (int) $id;
			$db->setQuery($query);
			$result = $db->loadObject();
			break;
	}
}
if (isset($result)) {
	if (is_object($result) && $result->section_title != '') {
		echo 'Раздел: ' . $result->section_title . ' Категория: ' . $result->category_title;
	} else if (!is_object($result)) {
		echo 'Раздел: ' . $result;
	}
}
?>