"); $username="iwtsgnf_bobcaspe"; $password="tet8Bimf"; $database="iwtsgnf_"; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query = "SELECT * FROM students WHERE `student_id`=$student_id"; $result = mysql_query($query); $user_first_name = mysql_result($result,0,"first_name"); $user_last_name = mysql_result($result,0,"last_name"); /* Get class list*/ $query = "SELECT * FROM classes WHERE 1"; $result_classes = mysql_query($query); $num_classes = mysql_numrows($result_classes); /* Get Student List */ $query = "SELECT * FROM students WHERE ("; $class_term = "1"; $semester_term = "1"; $year_term = "1"; if($class_id<>0) $class_term = "(`class_id`=$class_id)"; if($semester<>"0") $semester_term = "(`semester`='$semester')"; if($year<>0) $year_term = "(`year`='$year')"; $query = $query.$class_term." AND ".$semester_term." AND ".$year_term." )"; $result = mysql_query($query); $num=mysql_numrows($result); ?>
 

Alumni Student List of Members

Total of selected
"; $i=$i+1; } ?>
Last Name First Name Email Address Semester Year
$last_name $first_name $email_address $semester $year

Welcome

if you're not please logout

Using this list: 

  • Click on the Last Name to get more detailed information about a single member
  • Click on their Email Address to send them a message

© Copyright - The Caspe Group LLC 2008