function teacher_name_given_student_id($id) { return teacher_name_given_code(getField("users", "teacher_code", "where id={$id}")); }
$t->set("Teacher Name"); $t->set("Teacher Email"); $t->nextrow(); $tcodes = array(); $num = 1; foreach ($list as $o) { $tid = getfld("id", "users", "where teacher_code=" . $o->teacher_code . " and user_type='t'"); $temail = getfld("email", "users", "where teacher_code=" . $o->teacher_code . " and user_type='t'"); if (!isset($tcodes[$temail])) { $tcodes[$temail] = 1; } $t->set($num); $t->set($o->school_code); $t->set("<a href='a_support.php?user_id=" . $o->id . "'>" . $o->id . "</a>"); $t->set("<a href='a_support.php?userqry=" . $o->last_name . "'>" . $o->last_name . "</a>"); $t->set("<a href='a_support.php?userqry=" . $o->first_name . "'>" . $o->first_name . "</a>"); $t->set($o->teacher_code); $t->set("<a href='a_support.php?user_id={$tid}'>" . teacher_name_given_code($o->teacher_code)) . "</a>"; $t->set("<a href='mailto:{$temail}'>{$temail}</a>"); $t->nextrow(); $num++; } $t->dump(); ksort($tcodes); foreach ($tcodes as $e => $v) { echo "{$e},\n"; } w("\ndone."); ?>