Based on the result I saw, it's your file encoding issue.. Not htmlentities issue.. Try save your file in UTF8 encoding.. Kenny. Sent from my iPhone On 31-Aug-2010, at 6:18 PM, Marcel Bonar <marcboo@xxxxxxxxx> wrote: > I think you should try htmlentites() function in php and also > html_entity_decode...... > > this link from php manual for usage both of them: > > http://php.net/manual/en/function.htmlentities.php > http://www.php.net/manual/en/function.html-entity-decode.php > > On Sun, Aug 22, 2010 at 3:03 AM, Roger Head <headrog@xxxxxxxxx> wrote: > > > > > > > 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 <tjones10707%40yahoo.com>> > > To: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com> > > 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 <headrog > %40yahoo.com>> > > wrote: > > > > From: Roger Head <headrog@xxxxxxxxx <headrog%40yahoo.com>> > > Subject: Export to CSV > > To: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com> > > 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] > > > > > > > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed]