取category表所有的数据
{php}
$sql = $zbp->db->sql->get()->select($zbp->table['Category'])->sql;
$array = $zbp->GetListType('Category', $sql);
{/php}
<ul>
{foreach $array as $category}
<li><a href="{$category.Url}">{$category.Name}</a></li>
{/foreach}
</ul>
取post表 ID 大于 1 小于 4 的文章
{php}
$sql = $zbp->db->sql->get()->select($zbp->table['Post'])
->where(array('>', 'log_ID', "1"),array('<', 'log_ID', "4"))
->sql;
$array = $zbp->GetListType('Post', $sql);
{/php}
<ul>
{foreach $array as $article}
<li><span class="time">{$article.Time('m-d')}</span><span class="title"><a href="{$article.Url}" title="{$article.Title}">{$article.Title}</a></span></li>
{/foreach}
</ul>