Help for this page

Select Code to Download

Select or download this

$sth5 = $dbh->prepare("SELECT round,department,score FROM  trees WHERE
+ sport = \'$sport\' AND year = \'$year\' ORDER BY round DESC")|| die 
+"couldn't  prepareSQL statement";
$sth5->execute || die "can't execute sql statement";

...
    $rowcount++;

  }

Select or download this

my $statement = q{
    SELECT round
         , department
...
  $sport,
  $year,
);