# Takes the countryID as a parameter e.g. "12"
sub getCountryNameFromID{
    my $countryID = $_[0];
    my $sql = qq{ SELECT fullcountryname FROM countries WHERE (countryID="$countryID") };
    $qry = $dbhutils->prepare($sql);
    $qry->execute();
    @row = $qry->fetchrow_array;    
    my $countryname = $row[0];
    $qry->finish();
    return $countryname;
}