";
// Define your SQL statement to get available years
$query = "SELECT DISTINCT SUBSTR(d,1,2) y FROM s ORDER BY y DESC";
$sth = $dbh->query($query);
while($row = $sth->fetch(PDO::FETCH_ASSOC)) {
$yearsAvail[] = $row;
};
for ($year=0; $year
query($query);
while($row = $sth->fetch(PDO::FETCH_ASSOC)) {
$monthsAvail[] = $row;
}
for ($month=0; $monthquery($query);
$day = 0;
echo "";
echo "";
print_r ($yearsAvail[$year][y]."-".$monthsAvail[$month][m]);
echo "";
echo "";
echo " ";
while($row = $sth->fetch(PDO::FETCH_ASSOC)) {
$daysAvail[] = $row;
$fileName=$yearsAvail[$year][y]."-".$monthsAvail[$month][m]."-".$daysAvail[$day][d];
$recordsAvail[$day] = $fileName;
$day++;
echo ""
.$fileName." filled | "
.$fileName
." zoomable | ";
}
echo " ";
echo " ";
echo " | ";
$columnCount++;
if ($columnCount == 3) {
$columnCount = 0;
echo "