#!/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);
}