numRowsQ($sql)." Rows"; echo ""; $export = $db->query($sql); $fields = $db->numFields($export); $header = "\n\n"; for ($i = 0; $i < $fields; $i++) { $header .= "".$db->fieldName($export, $i) . ""; } $header .= "\n\n"; while($row = $db->fetchRow($export)) { $line = ''; $data .= "\n\n"; foreach($row as $value) { if ((!isset($value)) OR ($value == "")) { $value = "NULL"; } else { $value = str_replace('"', '""', $value); $value = '' . $value . ""; } $value = stripslashes($value); $line .= $value; } $data .= trim($line); $data .= "\n\n"; } echo $header; echo $data; echo ""; } $sql = "SELECT * FROM users"; printQuery($sql); $sql = "SELECT first_name, last_name, username, password FROM users"; printQuery($sql); ?>