", $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 "\n"; do { printf("\n", $myrow["START_DATE"], $PHP_SELF, $myrow["TRANSPNO"], $myrow["DESTINATION"], $myrow["END_DATE"], $myrow["TEXT1"]); } while ($myrow = mysql_fetch_array($result)); echo "
Dato Destinasjon Ankomstdato Fangenummer
%s %s %s %s
\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 "\n"; do { printf("\n", $myrow["TRANSPORTNO"], $PHP_SELF, $myrow["TRANSPORTNO"], $myrow["TRANSPDATE"], $myrow["NUMBER"]); } while ($myrow = mysql_fetch_array($result)); echo "
Nr. Ankomst Natzweiler Antall fanger
%s %s %s
\n"; } else { // no records to display echo "Sorry, no records were found!"; } } } } ?>