", $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
");
// show nntransport details for this prisoner
$result = mysql_query("SELECT * FROM NNTRANSP, PRISONER WHERE PRISONERNO BETWEEN FROMNO1 AND TONO1 AND PRISONER.RECNUMBER =$RECNUMBER",$db);
if ($myrow = mysql_fetch_array($result)) {
printf("Kom med transport nr. %s", $myrow["TRANSPORTNO"]);
printf(" til Natzweiler. Dato: %s", $myrow["TRANSPDATE"]);
}
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 {
// show alphabetic list of prisoners
$result = mysql_query("SELECT * FROM PRISONER ORDER BY SIR_NAME",$db);
if ($myrow = mysql_fetch_array($result)) {
echo "\n";
echo "Navn |
Fangenummer |
Fødselsdato |
\n";
do {
printf("%s %s |
%s |
%s |
\n",
$myrow["SIR_NAME"], $myrow["FIRST_NAME"],
$PHP_SELF, $myrow["RECNUMBER"], $myrow["PRISONERNO"],
$myrow["BORN"]);
} while ($myrow = mysql_fetch_array($result));
echo "
\n";
} else {
echo "Sorry, no records were found!";
}
}
}
?>