[% USE DBI %]

[% DBI.connect( 'dbi:mysql:personal', 'root', '' ) %]

[% query_category = DBI.prepare('select category from link group by category') %]
[% query_link = DBI.prepare('select * from link where category = ?') %]

[% FOREACH item = query_category.execute() %]

 [% FILTER redirect("links/${item.category}.html") %]
  
  [% INCLUDE header.tt2 %]
  [% FOREACH link = query_link.execute( $item.category )  %]

  ... do something ...
  
  [% END %]
  [% INCLUDE footer.tt2 %]

 [% END %]

[% END %]