Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- PHP/mySQL getting .csv file exported
- Jason Reljac
August 4, 2004, 2:19 pm
rate this thread
I'm looking for a little help.
I had a W2K server with Apache/PHP/mySQL installed and working. I had
a specific page that ran a mySQL SELECT INTO OUTFILE and dumped the
outfile into a web accessible directory. Now mySQL has been moved to
another server and my SELECT INTO OUTFILE no longer works.
mySQL help tells me SELECT INTO OUTFILE only can create a file on the
I've tried mapping a directory with no luck.
I looked into running a mysql -e command from the command line using
php's exec() but I can't get the results into a .csv file like I need.
So, can anyone help me with either getting the mysql -e to spit out to
a comma seperated file or point me in another direction to get the
file out of the DB into a .csv file on the webserver?
I hope that made sense.