pgHeader(); $usafachCore->database(); include "./includes/prevent.html"; $count = 1; $newdesig = $_GET['desig']; $ressql="SELECT a.descrp FROM lookup a join spec_desig b on a.value = b.designation where a.colmn = 'specdesig' and b.class='$year' and b.designation = '$newdesig'"; $res = mysqli_query($conn,$ressql); $count = mysqli_num_rows($res); $resrow = mysqli_fetch_array($res); $desc = $resrow[0]; //echo $ressql; function display_db_table($tablename,$person,$yr,$desig) { global $conn,$desc; //$year; // $year = $yr; $sql = "select distinct b.lname,b.fname,b.id_num from $tablename a join name_master b on a.id_num = b.id_num where a.class = '$yr' and a.designation = '$desig'"; if ($desig == 'cmbt') { // $sql = $sql . " or (b.class = '$yr' and b.combat = 'Yes')"; $desc = 'Combat Experience'; } $sql = $sql." group by b.lname,b.fname,b.id_num order by a.id_num"; // echo $sql. "
"; $result = mysqli_query($conn,$sql); $fncount = mysqli_num_rows($result); // echo $result . "here
"; $ii = 0; if ($fncount > 0) { echo '

'.$fncount. " " . $desc.'

'; print(" "); while($tbllRow = mysqli_fetch_array($result)) { $ii++; // echo $tbllRow[0].$tbllRow[1].$tbllRow[2]; print(''); if ($ii == 3) { $ii = 0; print(""); } } print("

"); } else { echo 'No graduates found for criteria ' . $desig . '.'; } } ?>
 

Class of



Select a graduate by clicking on the button with the graduate name.

 

View the memorial to the Class of 1963 War Casualties

'; } ?>