\n");
fwrite($handle, "\n");
// Iterate through all records
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
fwrite($handle, "\n");
fwrite($handle, "" . $row[0] . "\n");
fwrite($handle, "" . $row[1] . "\n");
fwrite($handle, "" . $row[2] . "\n");
fwrite($handle, "" . $row[3] . "\n");
fwrite($handle, "" . $row[4] . "\n");
fwrite($handle, "");
$temp = $row[5];
// Escape ampersands that aren't part of entities.
$temp = preg_replace('/&(?!\w{2,6};)/', '&', $temp);
$temp = preg_replace('/<(?!\w{2,6};)/', '<', $temp);
$temp = preg_replace('/<(?!\w{2,6};)/', '&rt;', $temp);
//replace newline characters with %0a
$temp = preg_replace('/\n+/s', '%0a', $temp);
$temp = preg_replace('/\r+/s', '', $temp);
fwrite($handle, $temp);
fwrite($handle, "\n");
fwrite($handle, "\n\n");
}
fwrite($handle, "\n");
fclose($handle);
} else {
echo "
Error executing query.
";
}
mysql_close($link);
?>