*Question 1-> There has to be a more efficient way to 
*store the queries because I am defining the queries 
*each time the method is called... but where should 
*they be stored? 

Create an .PM file called Queries.pm (or some such name as that.) In that file you start off with:

package Queries;
use DBI;
use strict;


#we really don't care about this as we are not 
#going to instantiate a Queries object. Just its 
#children

sub new {
    my $proto=shift;
    my $class=ref($proto) || $proto;
    my $self={}; 

    bless $self,$class;

    # We'll just put this here for clarity
    $self -> init();

    return $self;

}

sub init {
     my $self=shift; 

     #modify this to suit your situation
     my $self->{dbh}=DBI->connect('DBI:mysql',"username"
                                             ,"password"
                                  );
}

sub execute {
    my $self=shift;
    my @parms=@_;

    return unless $self->{dbh};
    return unless $self->{sql};
    
    $self->{sth}=$self->{dbh}->prepare($self->{sql});
}

sub fetchrow_hashref {
    my $self=shift;
    return unless $self->{sth};

    return $self->{sth}->fetchrow_hashref;

}
[download]

8<snip!8<

Now that you have the base class you can add more classes to the same .pm file as follows:

package loadusertable;
use Queries;
use strict;
use vars qw( @ISA );
@ISA=qw(Queries);

sub new {
    my $proto=shift;
    my $class=ref($proto) || $proto;
    my $self={};

    bless $self,$class;

    $self->init;  # we get that from the base class
    $self->{sql}="select * from users where id=?";

    return $self;

}
[download]

Now we have a class that when we instatiate it it connects to the database and can be used as follows:

use Queries;
use strict;

my $q=new loadusertable;

$q->execute(15);  

my $row=$q->fetchrow_hashref;
[download]

There is more that can be done with this. This was just a quick "something" I threw together to answer your question.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Peter L. Berghold --- Peter@Berghold.Net
"Those who fail to learn from history are condemned to repeat it."
[download]