Smarty

[boranucleare]

Hi All,
I would like to create a table from a template starting from a database.
here is my php page ...

[b]
$visualizza=new Smarty;
$visualizza->assign ('risultato',$db->get_results("SELECT * FROM team WHERE pubblica='si' ORDER BY name" ));
$visualizza->display('team.tpl');[/b]


my output had to be....like this..
<table>
<tr>
<td>data1</td>
<td>data2</td>
</tr>
<tr>
<td>data3</td>
<td>data4</td>
</tr>
</table>

I'm used to loop with foreach, but in this way I can only create a table with 1 col or 1 row (it depends from the choice I made).
Is it possible to have a table with more columns (for example 2 or 3) and a number of row depending from the records in the databases?
Please help me.
Thanks to all.
Bye

[boots]

http://www.phpinsider.com/smarty-forum/viewtopic.php?t=1391