1 Reply Latest reply: Jul 26, 2011 7:47 AM by yachts999 RSS

    Communication problem MYSQL > PHP > XML > Flash.

    originalevo Community Member

       

      I have driven myself into a corner with this so I hope someone here knows a solution.

       

       

      I am building a photogallery with a simple html layout but with a flash slideshow.

       

       

      The data for each album and photo are stored in a mysql database. Each photo-image is in one big folder on the server. With PHP I sort out which photo belongs to what album and display them accordingly. To start the slideshow people can click on a link near the album, this link will send a < href> with the album ID to an PHP file (xml.php) that will generated an XML output created from the MYSQL server. Here comes my problem:

       

       

      Loading XML into flash is no problem BUT I only know how to do this with a static or self supporting XML output. (xml.php needs the input of the album ID else it will not get the correct data). For now I have a temporary solution where I write the XML output from xml.php to a txt file and let Flash read from there, but is there a way where I can read directly from xml.php?