- or download this
my $rows = $dbh->selectall_arrayref($SQL,{Columns =>{}}) ;
$template->param(ROWS => $rows || []);
- or download this
<!-- TMPL_LOOP NAME=ROWS -->
<tr>
...
</td>
</tr>
<!-- /TMPL_LOOP -->
- or download this
$ticket = $query->param('TicketNo');
$detail = $query->param('Detail');
...
$sth1 = $dbh->prepare( $SQL );
$sth1->execute($details);
...