Untitled

PHP:

<?php

$smarty = new Smarty;

$sql = "SELECT Title, Content FROM data";
$query = mysql_query($sql) or die(mysql_error());

$data = array();

while($row = mysql_fetch_array($query)) {
    $info['Title'] = $row['Title'];
    $info['Content'] = $row['Content'];
    $data[] = $info;
}

$smarty->assign("data", $data);

?>


TPL:

<html>
    <body>
        {foreach item=data from=$data name=data}
            <h1>{$data.Title}</h1>
            <h3>{$data.Content}</h3>
        {/foreach}
    </body>
</html>