Mysql and Flash

Hi, I’m currently working on a project. Basically it is an information application where user just need to click and go to the next pages.

However, the problem is that I have a page which need to display a list of links or buttons depending on the database. So if the database has 5 links, my page will populate 5 buttons for it. If there are 10, the page will populate 10 buttons for it and so on.

My question is, how can I do these in Flash and how I can connect to Mysql database to get the number of buttons or links and according to the database, the Flash page will display the correct amount of buttons and eventually link up to the correct pages.

I would appreciate if anybody can post up a detailed tutorial or point me to somewhere which I can reference to.

Thank You!

You need to use a server-side script such as php or asp to get the data from the database and forward them into flash, and then you probably wanna use a for() or a while() loop to populate the buttons using createEmptyMovie() and attachMovie()

Thanks. How about using XML? Do you have any idea I can grab data off Mysql with XML?

There’s a tutorial on this site which teaches you how to grab data from a Database using Php and then the Php then changes into xml for you then you can easily grab it and do whatever you like with it in Flash Mx… its in the Php/Xml Section in the Tutorial Page

Hope that helps

can u handle this guy/ i can do it for ya. how much does this job pay? hehe :slight_smile:

Haha it’s a school project dude. I don’t get paid for these!! :frowning: