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