\n"); $error_message = getLanguageText('ERRORMSG-ACCESS-DENIED'); include "form.messages.php"; return; } $query = "SELECT * " . "FROM user_balance_save " . "WHERE school_num = $school_num " . "ORDER BY last_name, first_name"; $results = db_query($query); $data = array(); while ($row = db_fetch_assoc($results)) { $entry = array(); $balance = '$'.number_format($row['balance'],2); $posted_datetime = ''; if (intval($row['posted_time']) > 0) $posted_datetime = date("Y-m-d H:i:s",$row['posted_time']); $entry[] = $row['original_userid']; $entry[] = $row['original_type']; $entry[] = $row['first_name'].' '.$row['last_name']; $entry[] = $row['email']; $entry[] = $row['balance_year']; $entry[] = $balance; $entry[] = $row['posted']; $entry[] = $posted_datetime; $data[] = $entry; } $column_headers = array( getLanguageText('TEXT-USER-ID'), getLanguageText('TEXT-TYPE'), getLanguageText('TEXT-NAME'), getLanguageText('TEXT-EMAIL'), getLanguageText('TEXT-YEAR'), getLanguageText('TEXT-BALANCE'), getLanguageText('TEXT-POSTED'), getLanguageText('TEXT-POSTED-TIME'), ); $fname = genFileName("user-balances.csv"); xlsData($data,$column_headers,$fname); exit(); ?>