query($sql); $fields = $db->numFields($export); for ($i = 0; $i < $fields; $i++) { $header .= $db->fieldName($export, $i) . "\t"; } while($row = $db->fetchRow($export)) { $line = ''; foreach($row as $value) { if ((!isset($value)) OR ($value == "")) { $value = "\t"; } else { $value = str_replace('"', '""', $value); $value = '"' . $value . '"' . "\t"; } $value = stripslashes($value); $line .= $value; } $data .= trim($line)."\n"; } $data = str_replace("\r","",$data); if ($data == "") { $data = "\n(0) Records Found!\n"; } header("Content-type: application/x-msdownload"); header("Content-Disposition: attachment; filename=$filename.xls"); header("Pragma: no-cache"); header("Expires: 0"); print "$header\n$data"; } $sql = "SELECT first_name, last_name, username, password FROM users"; $filename = "Users_Information"; downloadXL($sql, $filename); ?>