my $sql = "select MNref from comment_record where MNid=" . "\"$self->{_MNid}\""; my $ccr = $dbh->prepare($sql); $ccr->execute() or die "$!";