my $query = "SELECT id FROM table WHERE user = ?";
my $results=$self->query($query, $user )->fetchrow_array;

sub query {
    # Do database query
    my($self, $sql, $val ) = @_;
    
    my $dbh=$self->param('dbh') or die "what's up with dbh?\n";
    my $sth = $dbh->prepare_cached( $sql );
    $sth->execute( $val );
    return $sth;
}