My-InstantCMS.Ru

        $sql = "SELECT con.*,
                       con.pubdate as fpubdate,
					   cat.title as cat_title, cat.seolink as catseolink,
					   cat.showdesc,
                       u.nickname as author,
                       u.login as user_login
                FROM cms_content con

        $sql = "SELECT con.*,
                       con.pubdate as fpubdate,
					   cat.title as cat_title, cat.seolink as catseolink,
					   cat.showdesc,
                       u.nickname as author,
                       u.login as user_login,
                       u.city
                FROM cms_content con

{foreach key=aid item=article from=$articles}    
 
    <div>
 
        {$article.author} {$article.city}  - <a href="{$article.url}">{$article.title}</a>     			    	
 
    </div>
 
{/foreach}
 

 
public function getZapis(){
 
            $sql = "SELECT * FROM cms_table";
 
            $result = $this->inDB->query($sql);
 
            if ($this->inDB->error()) { return false; }
 
            if (!$this->inDB->num_rows($result)) { return false; }
 
            $zapis = array();
 
            while ($zap = $this->inDB->fetch_assoc($result)){
 
                $zapis[] = $zap;
 
            }
 
            return $zapis;
 
        }
 

 
if ($do == 'view'){
        $zapis = $model->getZapis(); //В моделе нужно создать функцию getZapis
 
        $smarty = $inCore->initSmarty('components', 'com_test_view.tpl');
	$smarty->assign('zapis', $zapis);
        $smarty->display('com_test_view.tpl');
 
        return;
 
    }