", $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 "\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 { // 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 "\n"; do { printf("\n", $myrow["SIR_NAME"], $myrow["FIRST_NAME"], $PHP_SELF, $myrow["RECNUMBER"], $myrow["PRISONERNO"], $myrow["BORN"]); } while ($myrow = mysql_fetch_array($result)); echo "
Navn Fangenummer Fødselsdato
%s %s %s %s
\n"; } else { echo "Sorry, no records were found!"; } } } ?>