\n"); $error_message = getLanguageText('ERRORMSG-ACCESS-DENIED'); include "form.messages.php"; return; } // Get set of staff records $query = "SELECT * FROM people " . "WHERE school_num = $base_school_num " . "AND people_type = 'Staff' " . "ORDER BY last_name,first_name"; $results = db_query($query); $data = array(); while ($row = db_fetch_assoc($results)) { extract($row); $staff_category = intval($staff_category); $category = db_getVal("SELECT category_title FROM staff_categories WHERE school_num = $school_num AND record_num = $staff_category"); $userid = db_getVal("SELECT userid FROM users WHERE school_num = $base_school_num AND record_num = $user_num"); $data[] = array($first_name,$last_name,$email,$label_note,$category,$userid,$staff_description); } $column_headers = array( getLanguageText('TEXT-FIRST-NAME'), getLanguageText('TEXT-LAST-NAME'), getLanguageText('TEXT-EMAIL'), getLanguageText('TEXT-LABEL-NOTE'), getLanguageText('TEXT-CATEGORY'), getLanguageText('TEXT-USER-ID'), ); $fname = genFileName("staff.csv"); xlsData($data,$column_headers,$fname); exit(); ?>