Download mysql column into text file

[cornholio27]

I have a newsletter sign up box on my site, which adds the emails address to my mysql database.

 

I would like to be able to log in to the protected area of the site and have a link to download the email list as a text file, which is formatted ready to copy and paste in an email.

 

Any help/suggestions would be greatly appreciated.

[Lumio]

Whats your problem? Where do you need help?

[cornholio27]

Sorry, I wasn't clear enough.

 

My problem is the php/mysql code to collect the info and create a text file to a location of the user's choice. So, they click the link and are presented with a download dialog allowing them to save the generated text file.

[Lumio]

Okay 
Now I'm understanding...

You only have to change the headers:

<?php

  header('Content-type: application/pdf');

  header('Content-Disposition: attachment; filename="file.txt"');

 

  echo "Here you can output some text"

?>

[cornholio27]

Brilliant. Thanks very much for your help