title: Passing variables to actionscript from PHP/MySQL to play a audio file
body: <p>How can you bring in a path as a variable from php?  I have hundreds of mp3 file names stored in a My SQL database and I want to call the name, load it into a variable and then have it replace the URL in the call to the sound file.  I am all set with the PHP and database side of things, but I have been frustrated with the Flash part. I think it would just involve passing a variable from php to flash.  The web pages we are building would eventually have 10 - 15 files per page and each one would have a different sound file and a different image that you could click to trigger the sound.  First click would start the file and the second would stop the sound.  The images and sound files are all stored in the database.</p>
  
  <p>I found this code on another post and it is basically what I want to do.  Still missing the button part, but if I can figure out the variable from PHP I think it will open up a bunch of new options.</p>
  
  <pre>
  var soundRequest:URLRequest = "path/to/file.mp3"; //the path would be a variable passed from the database to php and then to the actionscript
  var s:Sound = new Sound(soundRequest);
  var sChannel = s.play(0, int.MAX_VALUE); //Causes it to repeat by the highest possible number to flash.
  //Above starts the sound immediatly (Streaming);
  
  //Now to wait for completion instead, pretend we didnt start it before.
  s.addEventLister(Event.SOUND_COMPLETE, onSComplete, false, 0, true);
  function onSComplete(e:Event):void
  {
     var sChannel = s.play(0, int.MAX_VALUE); //Causes it to repeat by the highest possible
  }
  </pre>