$result = mysql_query("SELECT f.name,t.* FROM `cdb_forums` as f,`cdb_threads` as t ORDER BY t.dateline DESC LIMIT 0 , 14");
while($row=mysql_fetch_array($result)){
$array[] = $row;
}
$tpl->assign("news",$array);
$tpl->display('index.html');
-----------------------------------------------------------------------------------------
index.html
<{section name=loop loop=$news}>
<tr>
<td><{$news[loop].name}></td>
<td><{$news[loop].subject}></td
</tr>
<{/section}>
while($row=mysql_fetch_array($result)){
$array[] = $row;
}
$tpl->assign("news",$array);
$tpl->display('index.html');
-----------------------------------------------------------------------------------------
index.html
<{section name=loop loop=$news}>
<tr>
<td><{$news[loop].name}></td>
<td><{$news[loop].subject}></td
</tr>
<{/section}>
呵呵