Storing data from querys in external file.

[lakrits]

Hi everybody!

This is my problem. I do a query like: select * from table1 using mySQL.

What I want to do now is store the resultset in an file for exampel file.txt.
Why I want to do this is because I want to be able to download this file.txt later on and use it in other programs.

Is this possible and if, how do I do that?

Sorry for my bad english. Isn't my native language.

[pete_bisby]

You need to look at the FileSystem functions within PHP. Look at file(), fwrite(), fputs() functions. You may also have a look at fputcsv(), if you want to create comma separated files.
(http://www.php.net/manual/en/ref.filesystem.php)

Or if English isn't your native lingo, use the following link to find PHP documentation in various languages.
(http://www.php.net/docs.php)

[lakrits]

Thank you very much. I will have a look at this and hopefully I will solve the problem.