Creating an online TXT document

[Grant_Cooper]

Hi, I need some advice. I don't know where to start looking. hehe It's kind of funny really. We have all our data stored in mysql for our college Calendar and don't know how to get it out for editing. My mysql server is not on the web server and I want to get all my info from our web server so I don't have to access my mysql server.

I really just need a text file with no special characters but when I access the html page and save it as a text file so our editors can format the text how they want in Microsoft word or pagemaker?

Any advice or a right way of doing this. I will be saving this file through our intranet from microsoft explorer.

[greg252]

Let me see if I got this right...
you are running mysql and have data stored in a table concerning college events.
This information is displayed on your website(?).
If so, eventhough mysql and webserver are not on same physical box, you can access mysql through the server.

In that case, you can build a small PHP script to pull all records out of the requested table and save (or display them) as needed.

BUT...
it sounds like the goal is to edit a mysql table. In that case, you can build a bit more complex PHP script to query the db based on conditions to select the desired record to edit, populate a form with the results and save the changes to (update) the table.

Got it?