Flash/Databases and Dynamic Content

I have a simple mySQL database. This database is called “products” and contains a table called “items”, each “item” has a hyper link, image and description, associated with it, in seperate columns of course :slight_smile:

What I’m wondering, is can I load these items dynamically from the products table, and display them into flash, into say, a blank movieclip?

Any help or tutorial links and the like would be much appreciated.

EDIT: Would I have to use PHP as an intemediary for a database connection?

sweet solution - love it!

creatify

glad you like it. :slight_smile: i think it’s nice because you can start building your flash using static xml files for testing even before you have your database set-up and populated, and then just set the php to mimic the output of your static xml files.
it’s definitely not as robust a solution as amfphp but it works perfect for most of my needs.

(edit: i hope you were referring to my solution and not amfphp :worried: )
(2nd edit: duh! i just realized creatify posted the link to amfphp in the first place. hah!)

Sure was, thanks treatkor - and I like that too, being able to use xml vs. the db in the interim - I do that w/ amfphp, creating a static #include file that has a temporary record set so I don’t have to connect to the db, but the switchover isn’t near as nice as changing and xml link, thanks again,

creatify