Did you try it on terminal, is there any problems? This looks like an encoding issue, do you have something like this? <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> Imp: This has to be the first line in the <head> section, otherwise browser will skip it. On Wed, Sep 1, 2010 at 4:38 PM, Kenny Tean <kennytean@xxxxxxxxx> wrote: > > > 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<marcboo%40gmail.com>> > 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<headrog%40yahoo.com>> > 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><tjones10707% > 40yahoo.com>> > > > To: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com><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><headrog > > %40yahoo.com>> > > > wrote: > > > > > > From: Roger Head <headrog@xxxxxxxxx <headrog%40yahoo.com> <headrog% > 40yahoo.com>> > > > Subject: Export to CSV > > > To: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com><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] > > > -- -Prasad C +91 994 672 5488 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Please don't print this e-mail unless absolutely necessary, lets save some trees, and Mother Nature [Non-text portions of this message have been removed]