一下是我的代码
test.php

[php]

<?php
require_once("conn.php");
include("d:/apache/apache2/htdocs/smarty/class/smarty.class.php");

$tpl=new Smarty();
$tpl->templates="d:/apache/apache2/htdocs/smarty/templates/";
$tpl->templates_c="d:/apache/apache2/htdocs/smarty/templates_c/";
$tpl->configs="d:/apache/apache2/htdocs/smarty/configs/";


$sql = "select * from test order by id desc limit 0,8";
$query = mysql_query($sql);
while($result[] = mysql_fetch_array($query)){
$tpl->assign("result",$result);
}


//载入模板
$tpl->display("test.tpl");
?>
[/php]
test.tpl

[php]
{foreach from=$result item=text}