", $myrow["DESCR"]);
} else {
// display individual record
if ($RECNUMBER) {
$result = mysql_query("SELECT * FROM PRISONER WHERE RECNUMBER=$RECNUMBER",$db);
$myrow = mysql_fetch_array($result);
printf("Fornavn: %s\n
", $myrow["FIRST_NAME"]);
printf("Etternavn: %s\n
", $myrow["SIR_NAME"]);
printf("Fangenummer: %s\n
", $myrow["PRISONERNO"]);
printf("Fødselsdato: %s\n
", $myrow["BORN"]);
print(" \n
");
printf("Arrestasjonsdato: %s\n
", $myrow["DATE_OF_ARR"]);
printf("Yrke ved arrestasjonen: %s\n
", $myrow["ARR_PROFESSION"]);
printf(" %s\n
", $myrow["REMARK"]);
$result = mysql_query("SELECT DEAD_DATE FROM PRISONER WHERE DEAD_DATE>0000-00-00 AND RECNUMBER=$RECNUMBER",$db);
if ($myrow = mysql_fetch_array($result)) {
printf(" Dødsdato %s", $myrow["DEAD_DATE"]);
}
$result = mysql_query("SELECT DEAD_WW_DATE FROM PRISONER WHERE DEAD_ww_DATE>0000-00-00 AND RECNUMBER=$RECNUMBER",$db);
if ($myrow = mysql_fetch_array($result)) {
printf(" Dødsdato %s", $myrow["DEAD_WW_DATE"]);
}
Print(" \n
");
Print(" \n
");
Print("Hans overførsel fra det ene fengslet til det andre: \n
");
Print(" \n
");
// show transport list for this prisoner
$result = mysql_query("SELECT * FROM TRANSPORT1 WHERE TRANSPORT1.RECNUMBER=$RECNUMBER",$db);
if ($myrow = mysql_fetch_array($result)) {
echo "\n";
echo "Dato |
Destinasjon |
Ankomstdato |
Fangenummer |
\n";
do {
printf("%s |
%s |
%s |
%s |
\n",
$myrow["START_DATE"],
$PHP_SELF, $myrow["TRANSPNO"], $myrow["DESTINATION"],
$myrow["END_DATE"],
$myrow["TEXT1"]);
} while ($myrow = mysql_fetch_array($result));
echo "
\n";
}
Print(" \n
");
// count and displays pictures available of this prisoner
$result = mysql_query("SELECT COUNT(*) FROM PICTURES WHERE PICTURES.RECNUMBER=$RECNUMBER",$db);
$myrow = mysql_fetch_array($result);
printf("Databasen inneholder %s", $myrow["COUNT(*)"]);
if ($myrow["COUNT(*)"]<1 or $myrow["COUNT(*)"]>1) {
Print(" bilder av ");
} else {
Print(" bilde av ");
}
$result = mysql_query("SELECT * FROM PRISONER WHERE RECNUMBER=$RECNUMBER",$db);
$myrow = mysql_fetch_array($result);
printf($myrow["FIRST_NAME"]);
printf(" %s", $myrow["SIR_NAME"]);
$result = mysql_query("SELECT COUNT(*) FROM PICTURES WHERE PICTURES.RECNUMBER=$RECNUMBER",$db);
$myrow = mysql_fetch_array($result);
if ($myrow["COUNT(*)"]<1) {
Print(". \n
");
} else {
Print(": \n
");
}
Print(" \n
");
Print(" \n
");
// show pictures of this prisoner
$result = mysql_query ("SELECT * FROM PICTURES WHERE PICTURES.RECNUMBER=$RECNUMBER");
while ($myrow = mysql_fetch_array($result))
{
// Display them to the screen...
echo "" ;
Print(" \n
");
printf(" %s\n
", $myrow["TEXT"]);
Print(" \n
");
Print(" \n
");
}
} else {
if ($TRANSPORTNO) {
//show details about this nntransport
$result = mysql_query("SELECT * FROM NNTRANSP WHERE TRANSPORTNO=$TRANSPORTNO",$db);
$myrow = mysql_fetch_array($result);
printf("Dato: %s\n
", $myrow["TRANSPDATE"]);
printf("Antall fanger: %s\n
", $myrow["NUMBER"]);
printf("Antall døde: %s\n
", $myrow["NOOFDEAD"]);
print(" \n
");
printf("%s\n
", $myrow["TEXT1"]);
print(" \n
");
print("Fangeintervall: ");
printf(" %s", $myrow["FROMNO1"]);
printf("–%s", $myrow["TONO1"]);
$result = mysql_query("SELECT FROMNO2, TONO2 FROM NNTRANSP WHERE FROMNO2>0 AND TONO2>0 AND TRANSPORTNO=$TRANSPORTNO",$db);
if ($myrow = mysql_fetch_array($result)) {
printf("; %s", $myrow["FROMNO2"]);
printf("–%s", $myrow["TONO2"]);
}
print(" \n
");
print(" \n
");
print("Fanger i denne transporten: \n
");
print(" \n
");
// show PRISONER list for this nntransport
$result = mysql_query("SELECT * FROM PRISONER, NNTRANSP WHERE PRISONERNO BETWEEN FROMNO1 AND TONO1 AND TRANSPORTNO=$TRANSPORTNO",$db);
if ($myrow = mysql_fetch_array($result)) {
// display list if there are records to display
do {
printf("%s %s
\n", $PHP_SELF, $myrow["RECNUMBER"], $myrow["FIRST_NAME"], $myrow["SIR_NAME"]);
} while ($myrow = mysql_fetch_array($result));
}
} else {
// show NNTRANSP list
$result = mysql_query("SELECT * FROM NNTRANSP ORDER BY TRANSPORTNO",$db);
if ($myrow = mysql_fetch_array($result)) {
print("Transporter til Natzweiler: \n
");
print(" \n
");
echo "\n";
echo "
Nr. |
Ankomst Natzweiler |
Antall fanger |
\n";
do {
printf("
%s |
%s |
%s |
\n",
$myrow["TRANSPORTNO"],
$PHP_SELF, $myrow["TRANSPORTNO"], $myrow["TRANSPDATE"],
$myrow["NUMBER"]);
} while ($myrow = mysql_fetch_array($result));
echo "
\n";
} else {
// no records to display
echo "Sorry, no records were found!";
}
}
}
}
?>