#!/usr/local/bin/perl


print "Content-type: text/plain\r\n\r\n";
print "<HTML><HEAD><TITLE>JARE38-42 DMSP DATA</TITLE></HEAD>";
print "<BODY BGCOLOR=\"#EAFFE8\">";
print "<H2><CENTER><b>DMSP DataBase (JARE38-42)</b></H2>";
#
# for FORM(POST)
$query_string=$ENV{'QUERY_STRING'};
@param = split(/&/, $query_string);
#
($field_name, $yy)=split(/=/, $param[0]);
($field_name, $mm)=split(/=/, $param[1]);
($field_name, $dd)=split(/=/, $param[2]);
 
print "Year: $yy, Month: $mm, Day: $dd<BR>";
 
open DB, "/usr/local/mysql/bin/mysql -N -e 'select dt,jare,fn from dmsp.gif where \"$yy-$mm-$dd\" < dt and dt < \"$yy-$mm-$dd 23:59:59\" order by dt'|";
 
$rl = 0;

print "<table>";
while (<DB>) {
 ($dd,$tt,$jare,$fn) = split();
 
 if($rl == 0) {print "<tr>"};

   print "<td><a href=./JARE",$jare,"_GIF/$fn>";
   print "<img src=./JARE",$jare,"_GIF/$fn width=200 hight=200></a><br><center>$dd $tt</center><br></td>\r\n";

 if($rl == 3) {print "</tr>"};
 $rl = ($rl+1)%4;
}
print "</table></center></html>";
