include_once("../inc/inc_header.php"); // Standard Header
include_once("../template.php"); // Page template
ob_start("template"); // Start Output Buffer
?>
Leadership Teacher - Affiliate Programs Teacher Participants
// Bring in list of all active GROUP records
$group_list = db_exec_sql("SELECT * FROM groups WHERE approval = '1' and year = '2009/2010' ORDER BY name, year","webdb");
$groupcount = mysql_num_rows($group_list);
if($groupcount){
while($list = mysql_fetch_object($group_list)){
if($id != $list->id){
$link = '?id='.$list->id;
}
else {$img = '-o';}
?>
echo $list->name . ', ' . $list->year . ', ' . $list->program;?>
if($id == $list->id){
$member_list = db_exec_sql("
SELECT group_member.*, users.firstname, users.lastname, users.email, users.current_school
FROM group_member
INNER JOIN users on group_member.user_id = users.id
WHERE users.email != '' AND group_member.group_id = '$id' AND group_member.level = '1' AND users.approval = '1' ORDER BY users.lastname","webdb");
//mail("jeremy@wedu.com", "group wtf", "SELECT group_member.*, users.firstname, users.lastname, users.email, users.current_school FROM group_member INNER JOIN users on group_member.user_id = users.id WHERE users.email != '' AND group_member.group_id = '$id' AND group_member.level = '1' ORDER BY users.lastname");
$membercount = mysql_num_rows($member_list);
if($membercount){
while($memberlist = mysql_fetch_object($member_list)){
?>
, ( )
}
}
else {
?>
No addresses found for this record.
}
}
unset($link,$img);
}
}
else{
?>
Error: No records found.
}
?>