Saving table content into a text file

[Anon]

Hi all,

I am using an Mysql db to display news items in a website. I would like a suggestion in order to have a button present which saves to content as it is listed on the page into a new text file. In other words i need a function which saves a *.txt file on the local HD.

Please advice,

Ciao

Dave.

[Anon]

Make a button that runs a php script. Have the php run the same query as the webpage but instead of echoing the results to the screen save them to a textfile on the server. Pull up a new page with a link to the newly created text file. They can then right-click the link and "Save target as" to download the textfile to their harddrive or they can click it and the browser will display the contents of the file (they could then either cut and paste or save).