sub get_meta_keywords {
my ($script,$parameter) = @_;
$sql_stmnt = "SELECT meta_keyword
FROM site_meta_keywords
WHERE script = ?
AND parameter = ?";
$sth = $dbh->prepare($sql_stmnt);
$sth->execute($script,$parameter);
my $keywords = $sth->fetchall_arrayref();
$sth->finish();
my $meta_keywords = join(', ', @$keywords);
return $meta_keywords;
}
####
#!/usr/bin/perl -w
my @keywords = qw(one two three);
my $keywords = \@keywords;
my $meta_keywords = join(',', @$keywords);
print $meta_keywords, "\n";
exit;
####
sub get_meta_keywords {
...
my @keywords;
while(my ($keyword) = $sth->fetchrow_array()) {
push(@keywords, $keyword);
}
$sth->finish();
my $meta_keywords = join(', ', @keywords);
return $meta_keywords;
}