MySQL Export CSV for MS Excel Using PHP

[lilman]

Is there a way I can code a script so I can export a table in
CSV for MS Excel format?

[Barand]

Check out SELECT ... INTO OUTFILE

http://dev.mysql.com/doc/refman/4.1/en/select.html

[lilman]

From what I've read, I wrote this code but it doesn't work.

$export="SELECT * INTO OUTFILE 'http://localhost/don/spreadsheet.xls' FROM survery";

Any help would be great. I am trying to actually export a table into Microsoft Excel 2000.

[lilman]

BTW when I run it I get this error:

Error Can't create/write to file 'http:\\localhost\don\spreadsheet.xls' (Errcode: 22) with query SELECT * INTO OUTFILE 'http://localhost/don/spreadsheet.xls' FROM survery

[Barand]

Try giving a path on your server instead of a url (C:/pth to file/don/spreadsheet.csv) and make sure you gave write permission