$name = 'modul_id' . $einheitid . '.txt'; } header("Content-disposition: filename={$name}"); header("Content-type: application/octetstream"); header("Pragma: no-cache"); header("Expires: 0"); // doing some DOS-CRLF magic... $crlf = "\n"; $client = getenv("HTTP_USER_AGENT"); if (ereg('[^(]*\\((.*)\\)[^)]*', $client, $regs)) { $os = $regs[1]; // this looks better under WinX if (eregi("Win", $os)) { $crlf = "\r\n"; } } if (isset($stgid)) { $sql_query = 'SELECT uid, nachname, vorname FROM campus.vw_student ' . 'WHERE studiengang_kz=' . $stgid . ' AND semester=' . $sem . ' AND verband=\'' . strtoupper($ver) . '\' AND gruppe=' . $grp . ' ORDER BY nachname'; } if (isset($einheitid)) { $sql_query = 'SELECT uid, nachname, vorname FROM campus.vw_benutzer JOIN tbl_benutzergruppe USING(uid) WHERE gruppe_kurzbz=\'' . $einheitid . '\' ORDER BY nachname'; } //echo $sql_query; if (!($result = $db->db_query($sql_query))) { die($db->db_db_last_error()); } $anz = $db->db_num_rows($result); for ($j = 0; $j < $anz; $j++) { $row = $db->db_fetch_object($result, $j); echo '#' . $row->nachname . ' ' . $row->vorname . $crlf . $row->uid . $crlf; }