[% USE DBI %]
[% DBI.connect('dbi:mysql:phones', 'user', 'password')%]
This is what we have

[% FOREACH fone = DBI.query('SELECT * FROM nokia') %]
    
    name : [% fone.modelno %]<br/>
    desc : [% fone.desc %]<br/>
    <img src="[% fone.image %]" width="60" height="60" alt="[% fone.modelno %]" /><br/>
    price: [% fone.price %]<br/>

    [% END %]
    <hr/>