$_hots = $this->model->DB->query('SELECT `img`,`name` FROM `hots`');
foreach ($_hots AS $_hots2) $_hot[] = $_hots2;
шаблон:
{foreach $_hot as $hot}
<img src="/public/images/hots/{$hot.preview}" border="0">
{/foreach}
или же лучше
$_hot = $this->model->DB->query('SELECT `img`,`name` FROM `hots`');
шаблон:
{foreach $_hot as $hot}
<img src="/public/images/hots/{$hot.preview}" border="0">
{/foreach}