my $query = "SELECT id FROM table WHERE user=$user"; my $results=$self->query($query)->fetchrow_array; #### #----------------------------------------------------------- # db query #---------------------------------------------------------- sub query { # Do database query my $self=shift; my $dbh=$self->param('dbh'); my $sth = $dbh->prepare(shift()); $sth->execute(); return $sth; }##END query ############################################################