Where am I making mistake?

In a number of ways:
You are not handling the possible error you store in   $err.
Consult the DBI.pm documentation how to work with   fetchrow_hashref.
You did not tell us much about the templating system to understand if there's anything wrong there.

Cheers, Sören