$| = 1;
print "Content-type: text/html\n\n";
# get records
@results = ();
$sql = "SELECT * FROM my_table";
print "
sql = $sql
\n";
$sth = $dbh->prepare($sql) or die("Could not prepare!" . $dbh->errstr);
$sth->execute() or die("Could not execute!" . $dbh->errstr);
print "
executed sql
\n";
$k = 0;
while (@results = $sth->fetchrow_array()) {
$data[$k] = [ @results ];
$k++;
}
$sth->finish;
for $a (0 .. $#data) {
print "
$a => ";
for $b (0 .. $#{$data[$a]}) {
print ", $data[$a][$b]";
}
}
print "
Done\n";
####
for $i (0 .. 137) {
print "
$i => ";
for $j (0 .. 18) {
$data[$i][$j] = "D".$i."B".$j;
}
}
####
if ($results[$j] eq "") {....}
####
while (@results = $sth->fetchrow_array()) {.....}