Code: Select all
$result = mysql_query ("SELECT DISTINCT subscribed_upload.email FROM subscribed_upload LEFT JOIN unsubscribed ON subscribed_upload.email = unsubscribed.email WHERE unsubscribed.email IS NULL") or die (mysql_error());
while($row = mysql_fetch_array($result))
{
if (filter_var($row[email], FILTER_VALIDATE_EMAIL))
{
$csv_output .= '"'.$row[email].'"';
$csv_output .= "\015\012";
}
}
//You cannot have the breaks in the same feed as the content.
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv; filename=MailExport_" . date("Y-m-d") .".csv");
print $csv_output;
exit;
mysql_close($sqlconn);
echo "Extract in progress - one moment please...";Is there a maximum amount this sort of script can handle at one time?