sub displayphone { #Retrieve current state of the object my $self = shift; #Prepare DB by establishing DB handle and statement handle my $dbh = $self->param('dbh'); my $sth = $dbh->prepare('Select * FROM directory ORDER BY last_name'); #Execute MySQL $sth->execute; #Create an array to hold the values returned from the DB before they are displayed in a form my @results; foreach ( ) }