Dynmaic Flash using SQL

Is it possible to build sql queries into flash so that when the flash loads on the page it will retrieve the latest data from the database?

re: Dynmaic Flash using SQL

You do not directly interface with your SQL database through Flash. You will use some 'middle-man' or server-side scripting/programming language, such as PHP as ASP(.NET).

Have a look at this article[1].

[1] http://www.kirupa.com/developer/acti..._php_mysql.htm

re: Dynmaic Flash using SQL

Hi I am wanting to do the same. Have managed to get XML output from my mYSQL database. Now I try with Flash. Where to put the URL?
so far I have this
1. //load xml
2. var xmlLoader:URLLoader = new URLLoader();
3. var xmlData:XML = new XML();
4. var xmlPath:String = "image-scroller.xml";
5. xmlLoader.load(new URLRequest(xmlPath));
6. trace("loading xml from: "+xmlPath);
7. xmlLoader.addEventListener(Event.COMPLETE, LoadXML);
8.
9. function LoadXML(e:Event):void {
10. trace("xml loading complete");
11. xmlData = new XML(e.target.data);
12. trace(xmlData.image); //we'll see each image xml element listed in the output panel with this xmlList
13.}
where at line 4 I give a manual list, can list be automated?

re: Dynmaic Flash using SQL

I looked at the example for this, created a dymanic text field, converted to movie, but cannot add the code snippet as instructed to this field. Maybe I did something wrong

Attached Files

slider.zip (23.3 KB, 0 views)