mySQL links into Flash?

[fuggedaboutit]

i'm a total beginner when it comes to using PHP/MySQL with Flash but i managed to get a site to display the data in a site a little while ago. I now need to make another similar site but this time one that imports clickable links into a Flash site.

Is this possible and if so please let me know how i can get this to work. Can you just add html link code to the database? Or do you need to use actionscript or PHP to convert the data into links?

thanks in advance

[lbeetles]

what you need to do is use php to get the info from the database, then format the php to xml and load the xml into flash.

try searching the forums for this method and you should see some examples.

[SlowRoasted]

Yeah make the links html, then you will have to change your textbox or other component to allow html in flash. Then the links will render.:P

[JoshuaJonah]

what you need to do is use php to get the info from the database, then format the php to xml and load the xml into flash.

try searching the forums for this method and you should see some examples.
Or even better, you could load the XML into an XSL page then read this page with ASP and temporarily store the value in an Oracle database. Then use Java script to extract them out of the Oracle database and pass them to PHP which could use GD to embed the text onto a BMP that you could then use GD to convert to a JPG. Then just use loadMovie to load them into Flash! (breathe)

See, wasn't that easy?

Now back to reality:
Please don't bring XML into the equation. If it's just a couple links, just use straight Flash/PHP/MySQL.:thumb2:

[fuggedaboutit]

Or even better, you could load the XML into an XSL page then read this page with ASP and temporarily store the value in an Oracle database. Then use Java script to extract them out of the Oracle database and pass them to PHP which could use GD to embed the text onto a BMP that you could then use GD to convert to a JPG. Then just use loadMovie to load them into Flash! (breathe)

See, wasn't that easy?

Now back to reality:
Please don't bring XML into the equation. If it's just a couple links, just use straight Flash/PHP/MySQL.:thumb2:

Thanks for all your replies, i've found this tutorial (http://www.kirupa.com/developer/actionscript/flashphpxml_integration.htm )which seems to do what i need without the need for XML. I know xml is fairly straight forward but i'm just getting to grips with basic php so it would confuse the hell out of me using them both. This example just uses actionscript with php so should be much easier to understand.
All i need is clickable links called in from the database, can anyone see any problem i might have acheiving that from the tutorial?

[JoshuaJonah]

No, you should be good. If you have any issues, don't hesitate to ask us. As you can tell, we reply quite fast:)

[fuggedaboutit]

No, you should be good. If you have any issues, don't hesitate to ask us. As you can tell, we reply quite fast:)

nice one, thanks a lot