Have you looked at the action script in flash? It may just be an easy fix there too.
ER -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Mort Sent: Friday, December 07, 2007 1:22 PM To: NYPHP Talk Subject: Re: [nyphp-talk] MySQL/Flash/Apostrophe issue Kristina Anderson wrote: > The previous programmers neglected to properly handle apostrophes and > there are many text strings displayed in the .swf files, unfortunately > what exists now is that whenever an apostrophe occurs, it cuts off the > rest of the string. > > One thing that I tried was to go into the MySQL database itself and > add the escape character before the apostrophes, this resulted in the > display of the encoded HTML for the apostrophe and not the actual > apostrophe. > > Well, it sounds like the apostrophe was properly escaped when placed into the MySQL database. If it is escaped, it doesn't store the escape charector in the database, it stores it as it is. What I'm guessing you need to do is escape/convert the apostrophe for Flash/Actionscript. At a guess, since Flash is so HTML centric, try converting the ' to ' _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
