$class Pledge Class");
}
else{
echo("$class Class
");
}
$results = mysql_query("SELECT first_name, last_name FROM brothers WHERE pledge_class = '$class' ORDER BY last_name ASC");
if (!$results) {
echo("DATABASE ERROR" . mysql_error());
}
while ( $result = mysql_fetch_array($results) ) {
$first_name = $result["first_name"];
$last_name = $result["last_name"];
$class2 = strtolower($class);
$first_name2 = strtolower($first_name);
$last_name2 = strtolower($last_name);
if($first_name != 'Morgan'){
if ( $pictures == 0 ) {
echo("");
echo("
$first_name $last_name
");
echo("
");
echo("
![](http://www.calakpsi.com/images/$class2/$first_name2" .
"_$last_name2.jpg)
" .
"$first_name $last_name
");
echo("
");
echo("
" .
"$first_name $last_name
");
echo("
$first_name $last_name [$class]
");
$results = mysql_query("SELECT major, minor, hometown, grad_year, bio FROM brothers WHERE first_name = '$first_name' AND last_name='$last_name' AND pledge_class = '$class'");
if (!$results) {
echo("DATABASE ERROR");
}
$result = mysql_fetch_array($results);
$major = $result["major"];
$minor = $result["minor"];
$hometown = $result["hometown"];
$grad_year = $result["grad_year"];
$bio = $result["bio"];
$class2 = strtolower($class);
$first_name2 = strtolower($first_name);
$last_name2 = strtolower($last_name);
echo("Name: $first_name $last_name
" .
"Class: $class
Major: $major
Minor: $minor" .
"
Graduation Year: $grad_year
Hometown: $hometown");
//if($bio){
echo("
Bio: $bio");
//}
} else {
echo("
AKPsi Actives
");
$results = mysql_query("SELECT first_name, last_name, pledge_class FROM brothers WHERE is_alumni = 0 ORDER BY last_name ASC");
if (!$results) {
echo("DATABASE ERROR" . mysql_error());
}
while ( $result = mysql_fetch_array($results) ) {
$first_name = $result["first_name"];
$last_name = $result["last_name"];
$class = $result["pledge_class"];
$class2 = strtolower($class);
$first_name2 = strtolower($first_name);
$last_name2 = strtolower($last_name);
if($first_name != 'Morgan'){
echo("");
echo("
" .
"$first_name $last_name
");
echo("