my (@ergebnisse,$set);

while(my @result = $sth->fetchrow_array()){
   $result[2] = '<a href=="link.pl">'.$result[2].'</a>' if($result[2] == 4);
  
   
   $set = '<img src="images/ic_parkingAvailable.gif">' if($result[2] == 4);

   my %hash = (
      ID => $result[0],
      NAME => $result[1],
      CAT => $result[2],
      CHECKED => $set,);
   push(@ergebnisse,\%hash);
}

$template->param(ABFRAGE => \@ergebnisse);

 <tmpl_loop name="ABFRAGE">
 <tr>
   <td>  <INPUT TYPE="text" NAME="" value="<tmpl_var name="ID">"></td>
   <td><tmpl_var name="NAME"></td>
   <td ><tmpl_var name="CAT"></td>
   <td ><tmpl_var name="CHECKED"></td>
 </tr>
 </tmpl_loop>