$sth = $dbh->prepare("select title,width,height,param,alt from menu");
$sth->execute;
$tmpl->param(menu => $sth->fetchall_arrayref({}));

print header, $tmpl->output;

__DATA__
<tmpl_loop menu>
<span class="mitem">
   <a title="<tmpl_var title>" href="?a=<tmpl_var param>">
   <img height="<tmpl_var height>" border="0"
                    src="i/<tmpl_var param>.png"
                    alt="<tmpl_var alt>"
                    width="<tmpl_var width>" />
   &nbsp;<tmpl_var param>&nbsp;
   </a>
</span>
</tmpl_loop>