#!/usr/local/bin/perl5 -w

use strict;
use DBI;
use CGI qw(:standard);

my $dbh = DBI->connect('DBI:mysql:tapebot:lid42','','')  
        || die "cannot connect to DB\n" .  DBI->errstr;

my $full = "\'F\'";
my %bighash = ();
my $sth;
my $nrows_max;
my $i = "2";
my %days = (
        '0' => 'Sunday',
        '1' => 'Monday',
        '2' => 'Tuesday',
        '3' => 'Wednesday',        
        '4' => 'Thursday',
        '5' => 'Friday',
        '6' => 'Saturday',
   ); 

my $aoa;
my $day_query = qq{
        SELECT last,keyno,btype
        FROM weekly
        WHERE btype =$full 
        AND day = ?
        ORDER by keyno
        };

my $day;
foreach $day (sort keys %days) {
($bighash{$day}{$aoa},$bighash{$day}{nrows},$bighash{$day}{nfields})
       = get_db_entries($sth,$day_query,$day);
}

$day = '5';
$i = '0';
print "\nnrows: ${ $bighash{$day}->{nrows} }\n";
print "\nnfields: ${ $bighash{$day}->{nfields} }\n";
print "aoa:  ${ $bighash{$day}->$aoa->[$i]->[2] } after\n";

$dbh->disconnect;

sub get_db_entries {
        my($s_handle,$qry,$d)= @_;
        my($nrows,$aoa,$nfields);
        $s_handle = $dbh->prepare($qry) 
          or die "Can't prepare statement: ". $dbh->errstr;;
        $nrows = $s_handle->execute($d) 
          or die "Can't execute statement: " . $dbh->errstr;
        print "\n sub nrows: $nrows\n";
        $aoa = $s_handle->fetchall_arrayref();
        $nfields = $s_handle->{NUM_OF_FIELDS};
        return(\$aoa,\$nrows,\$nfields);
}

##</code><code>##

mysql> select * from weekly where btype = 'F' and day = '0'
order by keyno limit 2;
+-------+-------+------------+-----+
| keyno | btype | last       | day |
+-------+-------+------------+-----+
|     8 | F     | 2003-09-28 |   0 |
|    58 | F     | 2003-09-28 |   0 |
+-------+-------+------------+-----+
2 rows in set (0.02 sec)

##</code><code>##

Use of uninitialized value in hash element at 
./hoAoA_ref_test.pl line 39.
Use of uninitialized value in hash element at 
./hoAoA_ref_test.pl line 39.

##</code><code>##

Use of uninitialized value in method lookup at 
./hoAoA_ref_test.pl line 50.
Can't call method "" on unblessed reference at 
./hoAoA_ref_test.pl line 50.