0) { $swhere = "AND schedule_num = $schedule"; } $query = "UPDATE users SET email_flag = '$flag' " . "WHERE school_num = $school_num " . "AND record_num IN (SELECT user_num " . "FROM user_account " . "WHERE school_num = $school_num " . "AND transaction_type = '$type' $swhere)"; db_query($query); $num = db_affected_rows(); $form_message = "Selected User Flags Set to '$flag' - $num Records"; header("Location: /?action=$action&form_message=".urlencode($form_message)); exit(); case 'list': $flag = db_escape_string($_GET['flag']); $query = "SELECT * FROM users WHERE school_num = $base_school_num AND email_flag = '$flag' ORDER BY last_name"; $results = db_query($query); $data = array(); if (db_num_rows($results)) { while ($row = db_fetch_assoc($results)) { extract($row); $data[] = array("$first_name", $userid, $email, $home_phone); } } $columnHeaders = array(getLanguageText('TEXT-NAME'), getLanguageText('TEXT-USERID'), getLanguageText('TEXT-PHONE'), getLanguageText('TEXT-EMAIL')); listDataCustom($data,$columnHeaders,'',array(),'N'); break; default: include $FormFile; break; } endTemplate(); ?>