Select Code to Download

my $kind = $query->param('kind');
my $searchterm = $query->param('searchterm');
...
  ORDER by $searchfield";  
my $sth = $dbh->prepare($stmt);
$sth->execute($searchterm);