Guys, When I select from a table I can't get the quotes and returns to desplay on the web page, I get; St. John�s Cap�s winning triple overtime and it should be St. John's Cap's winning triple overtime I think I should use the str_replace function. Roger Head (709)726-4323(home) (709)690-9006(cell), (709)729-0481(work) www.nlscoreboard.com ________________________________ From: Tony Jones <tjones10707@xxxxxxxxx> To: php-objects@xxxxxxxxxxxxxxx Sent: Tue, August 17, 2010 6:00:21 PM Subject: Re: Export to CSV If you want to export the results of the query you may do something like the following from the mysql> prompt select field1, field2, field3, field4 into outfile '/home/rhead/result.txt' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n' from your_table; This will produce a file in csv format, see website - http://dev.mysql.com/doc/refman/5.1/en/select.html for details. --- On Tue, 8/17/10, Roger Head <headrog@xxxxxxxxx> wrote: From: Roger Head <headrog@xxxxxxxxx> Subject: Export to CSV To: php-objects@xxxxxxxxxxxxxxx Date: Tuesday, August 17, 2010, 10:25 AM What is the best way to Export a Sql statment to a CSV or Excel file? Roger Head (709)726-4323(home) (709)690-9006(cell), (709)729-0481(work) [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
