Hi guys,
I got a music portfolio web site running PHP, MySQL and Flash. There’s a page showing all the artists my client worked for and when you click on a song title, this title is passed as a variable to a PHP page then to a Flash page. The Flash page contains an actionscript music player which then looks for the right audio file in the database and plays the song. Everything works great except for the dynamic text field which displays the song title. If the song title contains an apostrophe or a single quote, the Flash dynamic text field then shows the apostrophe preceded by a .
Here’s an image :
[FONT="]For example, the song Breaking up somebody’s home (by Nanette Workman) is written as is into the MySQL database. The display into the html page is fine ( no [/FONT][FONT="]), The problem is with the Flash dynamic text field.
I’ve spent many many hours searching the web trying to find the cause and the solution with no success.
The actual site is here : [/FONT]http://www.pierrepineault.com/contentFrame.php
Many thanks in advance.
Joshley
