Search Great War Images from the U of S

U of S Great War Database

As early as March 1916, the University of Saskatchewan Board of Governors decided to create a Roll of Honour by having "the names of all students, and others connected with the University who have enlisted, painted on the 'ribbons' in the corridors" of the College Building (now the Peter MacKinnon Building). This database, compiled by Professor Emeritus of History Michael Hayden, provides as much detail as could be discovered in university records and the National Archives on-line records about members of the University of Saskatchewan community who served in World War I. In as many cases as possible, a link is provided to the National Archives records to open the way for further research.


Search the database: "") { if($browsefield_heading[$_REQUEST['field']] == "" ){ $filter = "Filter not found"; }else{ $filter = "Filtered by " . $browsefield_heading[$_REQUEST['field']] . ": " . stripslashes($_REQUEST['search']) . "."; } } else { $filter = "Showing all names."; } ?>

Click on a name to get more detail.

"" && $criteria == "") { /* criteria might already be set */ $criteria = "where $_REQUEST[field] ='" . $_REQUEST['search'] . "'"; } $query = "SELECT WWI_identification.idno as idno, sn, 1gn as gn1, 2gn as gn2, 3gn as gn3, regno, bnenl, SlideNum FROM ((((((((((((WWI_identification LEFT JOIN WWI_AddressesNonMilitary ON WWI_identification.idno=WWI_AddressesNonMilitary.idno) LEFT JOIN WWI_birth ON WWI_identification.idno=WWI_birth.idno) LEFT JOIN WWI_death ON WWI_identification.idno=WWI_death.idno) LEFT JOIN WWI_decorations ON WWI_identification.idno=WWI_decorations.idno) LEFT JOIN WWI_MilitaryServiceAssignments ON WWI_identification.idno=WWI_MilitaryServiceAssignments.idno) LEFT JOIN WWI_MilitaryServiceAttestation ON WWI_identification.idno=WWI_MilitaryServiceAttestation.idno) LEFT JOIN WWI_MilitaryServiceEnd ON WWI_identification.idno=WWI_MilitaryServiceEnd.idno) LEFT JOIN WWI_rank ON WWI_identification.idno=WWI_rank.idno) LEFT JOIN WWI_siblings ON WWI_identification.idno=WWI_siblings.idno) LEFT JOIN WWI_spouse ON WWI_identification.idno=WWI_spouse.idno) LEFT JOIN WWI_UniversityOfSaskatchewan ON WWI_identification.idno=WWI_UniversityOfSaskatchewan.idno) LEFT JOIN WWI_wounds ON WWI_identification.idno=WWI_wounds.idno) LEFT JOIN WWI_SlideList ON WWI_identification.CBno = WWI_SlideList.ListNum $criteria GROUP by sn, gn1, gn2, gn3"; //$query = "SELECT WWI_identification.idno as idno, sn, 1gn as gn1, 2gn as gn2, 3gn as gn3, regno, bnenl FROM (((((((((((WWI_identification LEFT JOIN WWI_AddressesNonMilitary ON WWI_identification.idno=WWI_AddressesNonMilitary.idno) LEFT JOIN WWI_birth ON WWI_identification.idno=WWI_birth.idno) LEFT JOIN WWI_death ON WWI_identification.idno=WWI_death.idno) LEFT JOIN WWI_decorations ON WWI_identification.idno=WWI_decorations.idno) LEFT JOIN WWI_MilitaryServiceAssignments ON WWI_identification.idno=WWI_MilitaryServiceAssignments.idno) LEFT JOIN WWI_MilitaryServiceAttestation ON WWI_identification.idno=WWI_MilitaryServiceAttestation.idno) LEFT JOIN WWI_MilitaryServiceEnd ON WWI_identification.idno=WWI_MilitaryServiceEnd.idno) LEFT JOIN WWI_rank ON WWI_identification.idno=WWI_rank.idno) LEFT JOIN WWI_siblings ON WWI_identification.idno=WWI_siblings.idno) LEFT JOIN WWI_spouse ON WWI_identification.idno=WWI_spouse.idno) LEFT JOIN WWI_UniversityOfSaskatchewan ON WWI_identification.idno=WWI_UniversityOfSaskatchewan.idno) LEFT JOIN WWI_wounds ON WWI_identification.idno=WWI_wounds.idno $criteria GROUP by sn, gn1, gn2, gn3"; $sql_set = "set SQL_BIG_SELECTS=1"; $result_set = mysql_query($sql_set) or print("Couldn't set variable"); /* workaround for bizarre error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay */ $query_old = "select idno, sn, 1gn as gn1, 2gn as gn2, 3gn as gn3, regno, bnenl from WWI_identification $criteria order by sn, 1gn, 2gn, 3gn"; /* php choking on $line['1gn'] etc., so use aliases for those fields */ $result = mysql_query($query) or print("Query failed"); //echo mysql_error($link); while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { $numrows = mysql_numrows($result); $name = $line['sn'] . ", " . trim($line['gn1'] . " " . $line['gn2'] . " " . $line['gn3']); ?>
Name Regimental number Battalion/unit on enlistment
0) { echo PadCell($line['regno']); } else { echo " ";} ?>
1) { $names = "names"; } else { $names = "name"; } ?>

Back to intro page

'SS, W'"; } */ if ($browsefield == "notst") { $sql = "SELECT $browsefield, count(idno) as numhits from " . $browsefield_table[$browsefield] . " where ($browsefield > '' or $browsefield = '') and $browsefield <> '?' $criteria group by $browsefield"; } else { $sql = "SELECT $browsefield, count(idno) as numhits from " . $browsefield_table[$browsefield] . " where $browsefield > '' and $browsefield <> '?' $criteria group by $browsefield"; } $sql_old = "SELECT $browsefield FROM (((((((((((WWI_identification LEFT JOIN WWI_AddressesNonMilitary ON WWI_identification.idno=WWI_AddressesNonMilitary.idno) LEFT JOIN WWI_birth ON WWI_identification.idno=WWI_birth.idno) LEFT JOIN WWI_death ON WWI_identification.idno=WWI_death.idno) LEFT JOIN WWI_decorations ON WWI_identification.idno=WWI_decorations.idno) LEFT JOIN WWI_MilitaryServiceAssignments ON WWI_identification.idno=WWI_MilitaryServiceAssignments.idno) LEFT JOIN WWI_MilitaryServiceAttestation ON WWI_identification.idno=WWI_MilitaryServiceAttestation.idno) LEFT JOIN WWI_MilitaryServiceEnd ON WWI_identification.idno=WWI_MilitaryServiceEnd.idno) LEFT JOIN WWI_rank ON WWI_identification.idno=WWI_rank.idno) LEFT JOIN WWI_siblings ON WWI_identification.idno=WWI_siblings.idno) LEFT JOIN WWI_spouse ON WWI_identification.idno=WWI_spouse.idno) LEFT JOIN WWI_UniversityOfSaskatchewan ON WWI_identification.idno=WWI_UniversityOfSaskatchewan.idno) LEFT JOIN WWI_wounds ON WWI_identification.idno=WWI_wounds.idno where $browsefield > '' and $browsefield <> '?' $criteria GROUP by $browsefield"; echo " Browsing by: " . stripslashes($browsefield_heading[$browsefield]); echo "
    "; if ($_REQUEST['browsefield'] == "kdw") { echo "
  • " . " " . "full honour roll (70 names)" . "
  • \n"; } $result = mysql_query($sql) or print("Query failed"); //echo mysql_error($link); while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { if (trim($_REQUEST['browsefield']) == "notst") { if ($line['notst'] > "") { /* just take value */ } else { $line['notst'] = "student"; } $browsefield_display = $notst[$line['notst']]; } elseif ($_REQUEST['browsefield'] == "kdw") { $browsefield_display = $kdw[$line['kdw']]; } elseif ($_REQUEST['browsefield'] == "dthdt") { $browsefield_display = FormatDate($line['dthdt']); } else { $browsefield_display = $line[$browsefield]; } if ($line['numhits'] > 1) { $names = "names"; } else { $names = "name"; } echo "
  • " . " " . $browsefield_display . " (" . $line['numhits'] . " $names)
  • \n"; } ?>

Back to intro page

Peter MacKinnon Building memorials - alphabetical list

This list was compiled in the following order: starting on the first floor, north staircase; south to the end of the east wall; north along the west wall; south along the east wall; with the same process for the second floor. The numbers have been assigned for convenience of reference only.

View by location

0 order by sn, gn1, gn2, gn3"; /* php choking on $line['1gn'] etc., so use aliases for those fields */ $result = mysql_query($query) or print("Query failed"); while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { if ($line['CBNo'] >=1 && $line['CBNo'] <= 10) { $location = "First floor, centre east"; } elseif ($line['CBNo'] >=11 && $line['CBNo'] <= 27) { $location = "First floor, southeast"; } elseif ($line['CBNo'] >=28 && $line['CBNo'] <= 41) { $location = "First floor, southwest"; } elseif ($line['CBNo'] >=42 && $line['CBNo'] <= 79) { $location = "First floor, centre west"; } elseif ($line['CBNo'] >=80 && $line['CBNo'] <= 99) { $location = "First floor, northwest"; } elseif ($line['CBNo'] >=100 && $line['CBNo'] <= 134) { $location = "First floor, northeast"; } elseif ($line['CBNo'] >=135 && $line['CBNo'] <= 144) { $location = "Second floor, northeast"; } elseif ($line['CBNo'] >=145 && $line['CBNo'] <= 166) { $location = "Second floor, centre east"; } elseif ($line['CBNo'] >=167 && $line['CBNo'] <= 237) { $location = "Second floor, southeast"; } elseif ($line['CBNo'] >=238 && $line['CBNo'] <= 253) { $location = "Second floor, southwest"; } elseif ($line['CBNo'] >=254 && $line['CBNo'] <= 286) { $location = "Second floor, centre west"; } elseif ($line['CBNo'] >=287 && $line['CBNo'] <= 309) { $location = "Second floor, northwest"; } elseif ($line['CBNo'] >=310 && $line['CBNo'] <= 332) { $location = "Second floor, northeast"; } elseif ($line['CBNo'] == 2014) { $location = "2014 plaque"; } $name = $line['sn'] . ", " . trim($line['gn1'] . " " . $line['gn2'] . " " . $line['gn3']); echo " "; echo " \n"; echo " \n"; echo " \n"; echo " "; } ?>
Name List # Location
" . $name . "" . $line['CBNo'] . "" . $location . "

Back to intro page

Peter MacKinnon Building memorials - by location

This list was compiled in the following order: starting on the first floor, north staircase; south to the end of the east wall; north along the west wall; south along the east wall; with the same process for the second floor. The numbers have been assigned for convenience of reference only.

View alphabetical list

0 order by CBNo"; /* php choking on $line['1gn'] etc., so use aliases for those fields */ $result = mysql_query($query) or print("Query failed"); while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { if ($line['CBNo'] >=1 && $line['CBNo'] <= 10) { $location = "First floor, centre east"; } elseif ($line['CBNo'] >=11 && $line['CBNo'] <= 27) { $location = "First floor, southeast"; } elseif ($line['CBNo'] >=28 && $line['CBNo'] <= 41) { $location = "First floor, southwest"; } elseif ($line['CBNo'] >=42 && $line['CBNo'] <= 79) { $location = "First floor, centre west"; } elseif ($line['CBNo'] >=80 && $line['CBNo'] <= 99) { $location = "First floor, northwest"; } elseif ($line['CBNo'] >=100 && $line['CBNo'] <= 134) { $location = "First floor, northeast"; } elseif ($line['CBNo'] >=135 && $line['CBNo'] <= 144) { $location = "Second floor, northeast"; } elseif ($line['CBNo'] >=145 && $line['CBNo'] <= 166) { $location = "Second floor, centre east"; } elseif ($line['CBNo'] >=167 && $line['CBNo'] <= 237) { $location = "Second floor, southeast"; } elseif ($line['CBNo'] >=238 && $line['CBNo'] <= 253) { $location = "Second floor, southwest"; } elseif ($line['CBNo'] >=254 && $line['CBNo'] <= 286) { $location = "Second floor, centre west"; } elseif ($line['CBNo'] >=287 && $line['CBNo'] <= 309) { $location = "Second floor, northwest"; } elseif ($line['CBNo'] >=310 && $line['CBNo'] <= 332) { $location = "Second floor, northeast"; } elseif ($line['CBNo'] == 2014) { $location = "2014 plaque"; } $name = $line['sn'] . ", " . trim($line['gn1'] . " " . $line['gn2'] . " " . $line['gn3']); echo " "; echo " \n"; echo " \n"; echo " \n"; echo " "; } ?>
List # Name Location
" . $line['CBNo'] . "" . $name . "" . $location . "

Back to intro page

0) { /* detailed record */ /* set up arrays for navigation */ if ($_REQUEST['field'] == "kdw") { if ($_REQUEST['search'] == "SS") { $criteria = "where (KDW='SS' or KDW='SS, W')"; } elseif ($_REQUEST['search'] == "W") { $criteria = "where (KDW='W' or KDW='SS, W')"; } elseif ($_REQUEST['search'] == "HR") { $criteria = "where (KDW='K' or KDW='D' or KDW='DW')"; } else { $criteria = "where KDW='" . $_REQUEST['kdw'] . "'"; } } elseif ($_REQUEST['field'] == "notst") { if ($_REQUEST['search'] == "student") { $notst = ""; } else { $notst = $_REQUEST['search']; } $criteria = "where notst = '" . $notst . "'"; } elseif ($_REQUEST['field'] == "keyword") { $criteria = ""; } elseif ($_REQUEST['field'] > "") { $criteria = "where $_REQUEST[field] ='" . $_REQUEST['search'] . "'"; } $query = "SELECT WWI_identification.idno as idno, sn, 1gn as gn1, 2gn as gn2, 3gn as gn3, regno, bnenl FROM (((((((((((WWI_identification LEFT JOIN WWI_AddressesNonMilitary ON WWI_identification.idno=WWI_AddressesNonMilitary.idno) LEFT JOIN WWI_birth ON WWI_identification.idno=WWI_birth.idno) LEFT JOIN WWI_death ON WWI_identification.idno=WWI_death.idno) LEFT JOIN WWI_decorations ON WWI_identification.idno=WWI_decorations.idno) LEFT JOIN WWI_MilitaryServiceAssignments ON WWI_identification.idno=WWI_MilitaryServiceAssignments.idno) LEFT JOIN WWI_MilitaryServiceAttestation ON WWI_identification.idno=WWI_MilitaryServiceAttestation.idno) LEFT JOIN WWI_MilitaryServiceEnd ON WWI_identification.idno=WWI_MilitaryServiceEnd.idno) LEFT JOIN WWI_rank ON WWI_identification.idno=WWI_rank.idno) LEFT JOIN WWI_siblings ON WWI_identification.idno=WWI_siblings.idno) LEFT JOIN WWI_spouse ON WWI_identification.idno=WWI_spouse.idno) LEFT JOIN WWI_UniversityOfSaskatchewan ON WWI_identification.idno=WWI_UniversityOfSaskatchewan.idno) LEFT JOIN WWI_wounds ON WWI_identification.idno=WWI_wounds.idno $criteria GROUP by sn, gn1, gn2, gn3"; $query_old = "select idno from WWI_identification $criteria order by sn, 1gn, 2gn, 3gn"; $result = mysql_query($query) or print("Query failed"); echo mysql_error($link); while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { $current_id0 = $line['idno']; $previous_id[$current_id0] = $previous_id0; $next_id[$previous_id0] = $current_id0; $previous_id0 = $current_id0; } $query = "select WWI_identification.idno as idno, sn, 1gn as gn1, 2gn as gn2, 3gn as gn3, regno, bnenl, notst_full, kdw_full, idmem, CBNo, bdate, bploc, bpps, bpco, SlideNum from WWI_identification LEFT JOIN WWI_Lookup_NotStudent ON WWI_identification.notst = WWI_Lookup_NotStudent.notst LEFT JOIN WWI_Lookup_KilledDiedWounded ON WWI_identification.kdw = WWI_Lookup_KilledDiedWounded.kdw LEFT JOIN WWI_birth on WWI_identification.idno = WWI_birth.idno LEFT JOIN WWI_SlideList ON WWI_identification.CBno = WWI_SlideList.ListNum where WWI_identification.idno=" . $_REQUEST['idno'] . " order by sn, 1gn, 2gn, 3gn"; /* php choking on $line['1gn'] etc., so use aliases for those fields */ $result = mysql_query($query) or print("query failed"); echo mysql_error($link); while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { $regno = $line['regno']; $lastname = $line['sn']; $firstname = trim($line['gn1']); $firstnames = trim($line['gn1'] . " " . $line['gn2'] . " " . $line['gn3']); $name = $line['sn'] . ", " . trim($line['gn1'] . " " . $line['gn2'] . " " . $line['gn3']); if ($previous_id[$_REQUEST['idno']] > 0) { echo " previous"; } if ($next_id[$_REQUEST['idno']] > 0 && $previous_id[$_REQUEST['idno']] > 0) { echo " | "; } if ($next_id[$_REQUEST['idno']] > 0) { echo " next"; } if ($next_id[$_REQUEST['idno']] > 0 || $previous_id[$_REQUEST['idno']] > 0) { echo " | "; } ?> back to list of names | intro page $name

"; ?> "") { echo images_lightbox($slides); } ?>

Identification

"") { $notst_full = $line[notst_full]; } else { $notst_full = "student"; } if ($line['regno'] > 0) { echo " Regimental number: $line[regno]
"; } if ($line['bnenl'] > "") { echo " Battalion / unit at enlistment: $line[bnenl]
"; } echo " U of S affiliation at enlistment: $notst_full
"; if ($line[kdw_full] > "") { echo " Killed, died or wounded: $line[kdw_full]
"; $kdw = $line[kdw_full]; } if ($line['bdate']> "") { echo " Birth: "; echo FormatDate($line['bdate']) . ", "; if ($line['bploc'] > "") { echo $line['bploc'] . ", "; } if ($line['bpps'] > "") { echo $line['bpps'] . ", "; } echo $line['bpco']; echo "
"; } if ($line['CBNo'] > 0) { if ($line['CBNo'] >=1 && $line['CBNo'] <= 10) { $location = "First floor, centre east"; } elseif ($line['CBNo'] >=11 && $line['CBNo'] <= 27) { $location = "First floor, southeast"; } elseif ($line['CBNo'] >=28 && $line['CBNo'] <= 41) { $location = "First floor, southwest"; } elseif ($line['CBNo'] >=42 && $line['CBNo'] <= 79) { $location = "First floor, centre west"; } elseif ($line['CBNo'] >=80 && $line['CBNo'] <= 99) { $location = "First floor, northwest"; } elseif ($line['CBNo'] >=100 && $line['CBNo'] <= 134) { $location = "First floor, northeast"; } elseif ($line['CBNo'] >=135 && $line['CBNo'] <= 144) { $location = "Second floor, northeast"; } elseif ($line['CBNo'] >=145 && $line['CBNo'] <= 166) { $location = "Second floor, centre east"; } elseif ($line['CBNo'] >=167 && $line['CBNo'] <= 237) { $location = "Second floor, southeast"; } elseif ($line['CBNo'] >=238 && $line['CBNo'] <= 253) { $location = "Second floor, southwest"; } elseif ($line['CBNo'] >=254 && $line['CBNo'] <= 286) { $location = "Second floor, centre west"; } elseif ($line['CBNo'] >=287 && $line['CBNo'] <= 309) { $location = "Second floor, northwest"; } elseif ($line['CBNo'] >=310 && $line['CBNo'] <= 332) { $location = "Second floor, northeast"; } elseif ($line['CBNo'] == 2014) { $location = "2014 plaque"; } echo " College Building memorial: " . $location . "
"; if ($line["SlideNum"] > "") { echo "Slide number(s): " . $line["SlideNum"]; echo "
"; } } if (trim($line['idmem']) > "") { echo " Notes: " . trim($line['idmem']); } echo "
"; } /* **** UNIVERSITY OF SASKATCHEWAN ATTENDANCE **** */ $query = "select UScoll, USlvers, USdegdt, USmem, USentdt, USlvedt, USdeg, UShors from WWI_UniversityOfSaskatchewan where idno=" . $_REQUEST['idno']; $result = mysql_query($query) or print("Query failed"); $numrows = mysql_numrows($result); if ($numrows > 0) { ?>

U of S attendance

0) { $USentdt = $line['USentdt']; } if ($line['USlvedt'] > 0) { $USlvedt = $line['USlvedt']; } if ($line['USdegdt'] > 0) { $USdegdt = $line['USdegdt']; } echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; $USentdt = ""; $USlvedt = ""; $USdegdt = ""; } ?>
Entry date College Left - date Left - reason Degree Degree - date Notes
" . PadCell($USentdt) . "" . PadCell($line['UScoll']) . "" . PadCell($USlvedt) . "" . PadCell($line['USlvers']) . "" . PadCell($line['USdeg']) . "" . PadCell($USdegdt) . "" . PadCell($line['USmem']) . "
0) { echo "

Military service - attestation

"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo " Volunteer/drafted: "; if ($line['vol'] == 1) { echo "volunteer"; } else { echo "drafted"; } $ageyears = floor($line['agemos']/12); $agemonths = $line['agemos'] % 12; if ($agemonths > 0) { $agedisplay = $ageyears . " years, " . $agemonths . " months"; } elseif ($ageyears > 0) { $agedisplay = $ageyears . " years"; } echo "
"; echo " Attestation place: " . $line['attpl'] . "
"; echo " Attestation date: " . FormatDate($line['attdt']) . "
"; echo " Present address: " . $line['presadd'] . ", " . $line['presprov'] . "
"; echo " Occupation: " . $line['occup'] . "
"; echo " Religion: " . $line['rel'] . "
"; echo " Age: " . $agedisplay . "
"; if ($line['htin'] > 0) { echo " Height (inches): " . $line['htin'] . "
"; } if ($line['chexpcm'] > 0) { echo " Chest expansion (inches): " . $line['chexpcm'] . "
"; } if ($line['amtexpcm'] > 0) { echo " Amount of expansion (inches): " . $line['amtexpcm'] . "
"; } if ($line['marks'] > "") { echo " Marks: " . $line['marks'] . "
"; } if ($line[prevms_full] > "") { echo " Previous military service: " . $line[prevms_full] . "
"; } if ($line['prevmsl'] > 0) { echo " Previous military service (length): " . $line['prevmsl'] . "
"; } if ($line['attmem'] > 0) { echo " Notes: " . $line['attmem'] . "
"; } } } /* **** MILITARY SERVICE - ASSIGNMENTS **** */ $query = "select * from WWI_MilitaryServiceAssignments where idno=" . $_REQUEST['idno']; $result = mysql_query($query) or print("Query failed"); $numrows = mysql_numrows($result); if ($numrows > 0) { ?>

Military service - assignments

"; echo " "; echo " "; echo " '; echo " "; echo " "; echo " "; echo " "; echo " "; } ?>
Group Type Location First known date Last known date Reason for end of assignment Notes
" . PadCell($line['assgrp']) . "" . PadCell($line['asstyp']) . "" . PadCell($line['assloc']); if ($line['assloc'] > "" && $line['assco'] > "") { echo ", "; } if ($line['assco'] > "") { echo $line['assco']; } if ($line['assloc'] == "" && $line['assco'] == "") { echo " "; } echo '" . PadCell($line['assdt1st']) . "" . PadCell($line['assdtlst']) . "" . PadCell($line['assendreas']) . "" . PadCell($line['assmem']) . "
0) { ?>

Military service - end

"; if ($line['eosdt'] <> "0000-00-00") { echo " "; } else { echo " "; } if ($line['eosloc'] > "") { echo " "; } else { echo " "; } echo " "; echo " "; echo " "; } ?>
Date Location Reason Notes
" . FormatDate($line['eosdt']) . " $line[eosloc]" . ", " . "$line[eosco] " . PadCell($line['eosreas']) . "" . PadCell($line['eosmem']) . "
0) { ?>

Rank

"; echo " "; if ($line['rankdt'] <> "0000-00-00") { echo " "; } else { echo " "; } echo " "; echo " "; } ?>
Rank Date Notes
$line[rank]" . FormatDate($line['rankdt']) . " " . PadCell($line['rankmem']) . "
0) { ?>

Decorations

"; echo " "; echo " "; echo " "; } ?>
Decoration type Notes
" . PadCell($line['dectyp']) . "" . PadCell($line['decmem']) . "
0) { ?>

Wounds

"; echo " "; if ($line['wnddt'] <> "0000-00-00") { echo " "; } else { echo " "; } echo " "; echo " "; } ?>
Wound type Date Notes
" . PadCell($line['wndtyp']) . "" . FormatDate($line['wnddt']) . " " . PadCell($line['wndmem']) . "
0) { while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "

Death

"; echo " Date of death: " . FormatDate($line['dthdt']) . "
"; $cause['D'] = "disease"; $cause['DW'] = "died of wounds"; $cause['K'] = "killed"; $cause['KIA'] = "killed in action"; if ($cause[$line['dthcse']] > "") { $death_cause = $cause[$line['dthcse']]; } else { $death_cause = $line['dthcse']; } echo " Cause: $death_cause
"; if ($line['dthloc'] > "") { echo " Location: "; echo $line['dthloc']; if ($line['dthps'] > "") { echo ", "; } if ($line['dthps'] > "") { echo $line['dthps']; } if ($line['dthco'] > "") { echo ", "; } if ($line['dthco'] > "") { echo $line['dthco']; } } } } ?> 0) { while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { if ($line['sibsn'] > "") { $Sibling = $line['sibsn'] . ", " . trim($line['sib1gn'] . " " . $line['sib2gn'] . " " . $line['sib3gn']); } If($line['sibsn']>"") { If ($line['sibhasb']>"") { $SiblingAddress = $line['sibhasb'] . ", " . $line['sibhaloc'] . ", "; } If($line['sibhaps']>"") { $SiblingAddress .= $line['sibhaps'] . ", " . $line['sibhaco'] . " (" . $line['sibhadts'] . ")"; } } if ($line['spmn'] > "") { $Spouse = $line['spmn'] . ", " . trim($line['sp1gn'] . " " . $line['sp2gn'] . " " . $line['sp3gn']); } if ($line['spmn'] > "") { if ($line['sphasn']>"") { $HomeAddress = $line['sphasn'] . ", " . $line['sphaloc'] . ", "; } if ($line['sphaps'] > "") { $HomeAddress .= $line['sphaps'] . ", " . $line['sphaco'] . " (" . $line['sphadts'] . ")"; } } if ($line['parsn'] > "") { $Parent = $line['parsn'] . ", " . trim($line['par1gn'] . " " . $line['par2gn'] . " " . $line['par3gn']); } if ($line['parsn'] > "") { if ($line['parhasn']>"") { $ParentAddress = $line['parhasn']; } if ($line['parhasn'] > "" && $line['parhaloc'] > "") { $ParentAddress .= ", "; } if ($line['parhaloc'] > "") { $ParentAddress .= $line['parhaloc'] . ", "; } if ($line['parhaps'] > "") { $ParentAddress .= $line['parhaps'] . ", " . $line['parhaco'] . " (" . $line['parhadts'] . ")"; } } if ($Spouse > "" || $Sibling > "" || $Parent > "") { echo "

Family

"; } if ($Spouse > "") { echo " Spouse: " . $Spouse . "
"; } if ($HomeAddress > "") { echo " Home address: " . $HomeAddress . "
"; } if ($Sibling > "") { echo " Sibling: " . $Sibling . "
"; } if ($SiblingAddress > "") { echo " Sibling address: " . $SiblingAddress . "
"; } if ($Parent > "") { echo " "; if ($line['parfm'] == 1) { $ParentType = "Father"; } else { $ParentType = "Mother"; } echo $ParentType . ": "; echo $Parent . "
"; } if ($ParentAddress > "") { echo " $ParentType" . "'s Address: "; echo $ParentAddress . "
"; } if ($line['paroccup'] > "") { echo " $ParentType" . "'s Occuption: "; echo $line['paroccup'] . "
"; } } } /* **** NON-MILITARY ADDRESSES **** */ $query = "select * from WWI_AddressesNonMilitary where idno=" . $_REQUEST['idno']; $result = mysql_query($query) or print("Query failed"); $numrows = mysql_numrows($result); if ($numrows > 0) { ?>

Non-military addresses

"; echo ""; echo " "; if ($line['dtadrfst'] > 0) { echo " "; } else { echo " "; } if ($line['dtadrlst'] > 0) { echo " "; } else { echo " "; } echo " "; echo " "; echo " "; } ?>
Address Occupation Earliest date Latest date Source Notes
"; if($line['adrsn']>"") { echo $line['adrsn'] . ", "; } if($line['adrloc']>"") { echo $line['adrloc']; } if($line['adrco']>"" && $line['adrloc']>"") { echo ", " . $line['adrco']; } else { echo PadCell($line['adrco']); } echo "" . PadCell($line['occup']) . "" . PadCell($line['dtadrfst']) . " $line[dtadrlst] " . PadCell($line['source']) . "" . PadCell($line['adrmem']) . "
0) { ?>

Sources

0) { $url = "https://www.bac-lac.gc.ca/eng/discover/military-heritage/first-world-war/" . "first-world-war-1914-1918-cef/Pages/list.aspx?k=RegimentNum%3a%22" . $regno . "%22"; /* $url = "http://www.collectionscanada.gc.ca/databases/cef/001042-110.01-e.php?PHPSESSID=mtfpu2bitu57jqrubkik120j13&q1=&q2=&q3=" . $regno . "&interval=20";*/ /* $url = "http://data4.collectionscanada.ca/netacgi/nph-brs?s1=&s2=&s3=" . $regno . "&Sect4=AND&l=20&Sect1=IMAGE&Sect2=THESOFF&Sect5=CEF6PEN&Sect6=HITOFF&d=CEF6&p=1&u=http%3A%2F%2Fwww.collectionscanada.ca%2Farchivianet%2F02010602_e.html&r=0&f=S"; old url */ } else { $url = "https://www.bac-lac.gc.ca/eng/discover/military-heritage/first-world-war/" . "first-world-war-1914-1918-cef/Pages/list.aspx?k=Surname%3a%22" . $lastname . "%22+AND+GivenName%3a%22" . $firstname . "%22"; /* $url = "http://www.collectionscanada.gc.ca/databases/cef/001042-110.01-e.php?PHPSESSID=qrsfjtonpplh8jh7k9trqnr7s7&q1=" . $lastname . "&q2=" . $firstname . "&q3=&interval=20";*/ /* $url = "http://data4.collectionscanada.ca/netacgi/nph-brs?s1=" . $lastname . "&s2=" . $firstname . "&s3=&Sect4=AND&l=20&Sect1=IMAGE&Sect2=THESOFF&Sect5=CEF6PEN&Sect6=HITOFF&d=CEF6&p=1&u=http%3A%2F%2Fwww.collectionscanada.ca%2Farchivianet%2F02010602_e.html&r=0&f=S"; old url*/ } echo " National Archives reference: $line[NAref]"; /* if ($line['NAref'] <> "not found") { echo " [ search]"; } */ echo "
"; echo " College Building list #: " . FormatNumber($line['CBno']) . "
"; echo " Roll of Honour list #: " . FormatNumber($line['RHno']) . "
"; echo " Roll of Service (1928) #: " . FormatNumber($line['RoSno']) . "
"; echo " Long List #: " . FormatNumber($line['LLno']) . "
"; /* **** LINKS TO MORE INFORMATION **** */ $query = "select url from WWI_links where idno=" . $_REQUEST['idno']; $result_url = mysql_query($query) or print("Query failed"); $numrows = mysql_numrows($result); if ($numrows > 0) { $greatwar_link = 1; } if ($line[kdw] == "K" || $line[kdw] == "D" || $line[kdw] == "DW" || $line['NAref'] <> "not found" || $greatwar_link) { echo "

Links to more information

"; echo " "; } } /* end while */ } } ?> "0000-00-00") { return intval($date_array[2]) . " " . $month[$date_array[1]] . " " . $date_array[0]; } else { return ""; } } function FormatNumber ($number) { if ($number > 0) { return $number; } else { return ""; } /* blanks numbers that defaulted to zero (in this database, zero is never a meaningful value) */ } function PadCell ($text) { if ($text > "") { return $text; } else { return " "; } } function images_lightbox($slides) { $image_path = "/sites/greatwar.usask.ca/files/Images/HonourRoll"; $slide_list = split("\,",$slides); $slide_num = strtoupper($slide_list[0]); $filename = ereg_replace("-","",$slide_num) . ".jpg"; $text = '

'; if (count($slide_list) > 1) { $text .= '

'; $count = 0; foreach ($slide_list as $slide_num) { $slide_num = strtoupper($slide_num); $count++; if ($count > 1) { $filename = trim(ereg_replace("-","",$slide_num) . ".jpg"); $text .= '' . $count . ''; } } $text .= '

'; } $textsample = '

2 3 4 5 6 7 8 9

'; return $text . "\n"; } ?>