Taking info from a database

[thesween]

Hello, I've decided to look into using koolmoves to show info from a database.. still not fully understanding it all... does anyone know how I can use numbers in a db to change a movie to a particular frame depending on the number.

So, if it has 1 in the db, it shows frame 1. If 2 in db, it shows frame2... etc etc

Also, how to to simply show the info in a db?

Cheers
Steve

[blanius]

Sure, it's not very difficult. The main thing is that Flash cannot directly access the database you need a server sided script to access the database and then provide the info to flash. There are several examples of this on the http://koolexchange.com including guestbooks and such. You need to learn some basic PHP and MYSQL to do it. Don't be intimidated by it. Start with learning how to create a database and then learn how to basically access the database and display it in HTML in the browser. When you can do that it's a simple matter to send either XML or variables via loadVars to flash instead of the HTML.

[thesween]

Thanks for the quick reply.. I know how to create a db and can access the info with .net and stuff, I can see how it works better now from your explaination woohoo! Exellent, thanks again Bret

Cheers
Steve

[blanius]

If you are comfortable with .net then just build a server script that queries the DB and outputs the variable.

[thesween]

Good idea mate!! Will do. Thanks again for the help!

Steve