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]
