Документация по созданию компонента для Joomla 2.5 - страница 3 - Разработка расширений для Joomla 2.5

// Store the data.
if (!$table->store())
{
	$this->setError($table->getError());
	return false;
}

public function display($tpl = NULL)
	{

$user = &JFactory::getUser();
..................
..................

		if ($items) {
			$access = new stdClass();
			$access->canEdit = $user->authorize("com_content", "edit", "content", "all");
			$access->canEditOwn = $user->authorize("com_content", "edit", "content", "own");
			$access->canPublish = $user->authorize("com_content", "publish", "content", "all");

..................
..................
}
		else {
			echo "<h3> тут пусто</h3>";
		}

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and of.status = 1' at line 4 SQL=SELECT count(*) as cnt FROM jos_orders as of where of.id= and of.status = 1

$query = 'SELECT count(*) as cnt
			FROM #__orders as of
			where of.id='.$office->id.'
				and of.status = 1';

$query = 'SELECT count(of.id) as cnt
			FROM #__orders as of
			where (of.id='.(int)$office->id.')
			  and (of.status = 1)';