Getting Flash to read information from MySql

I currently use Flash MX 2004 and wondered if anyone could point me in the right direction of a good resource for Getting Flash to take information from a MySql Database.

Basically I am creating a game that consists of rooms.  I could fairly easily create each individual rooms in flash with all the various objects/monsters/etc in the room, but I would prefer for to be able to store all the information about the rooms in a database, so when a person enters the room, it loads up this information.  Is this possible? and how difficult is it?

Thanks in advance.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

This is possible but would be somewhat difficult. My suggestion is to have Flash call a PHP page that would read from the mysql server the data and then return it to flash in xml format. This is better because the data is neatly formatted in xml making it easy for flash to parse. Now the only concern would probably be how to store the data as well as how the xml format should be. After that comes the grunt work of creating the PHP page and then the getting flash to do the right thing after getting the xml data.

I recommend you to take a look at this web-site:
AMFPHP is open-source engine that makes it hell easier to communicate with mysql database, becase you don't have to wrap all the query results into xml to have it unwrap right after it reaches your flash application. This engine enables you directly recieve results from db and even use it as input to flash data-aware components...  Samples and tutorials included... easy to use. Take a look.

( Answer to your question: yes it's possible to do that... and with amfphp, communication with db will not be flash specific task.. so it's enough if you have some experience with mysql db. Processing recieved data in flash , that's another thing... :o)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ExpressionsAuthor Commented:
Ill have a look and tell you how I get on.
ExpressionsAuthor Commented:
Opps I thought I had answered this.


I will split the points but give more to ivan_os as his gave more information.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Flash

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.