How to receive data from a database?

[Kirderf]

1. I have a mysql database with 4 fields: ID, Type, Price and Available.
2. In a movie named "display_mc" have my flash file with 4 dynamic textfields named ID_txt, Type_txt, Price_txt and Available_txt.
3. In the main stage I have a series of buttons. When I click on each button I want to pull data from a database and send it to the display text fields in my flash movie.
4. My server supports php.

Can anyone help me here? I need this to work for me at least once!

I'd gladly pay you on Thursday
for a hamburger today!

 

[billwatson]

i have an example or 2 you can download

http://billwatson2.no-ip.info/public/flash/flash.html

 

[Kirderf]

Thanks Bill,
I wonder if you have ever tried to load text from a database into dynamic text fields?
I have each button set up individually(see sample code), but I really need to figure a way to make this editable outside of the flash file.

Here is the button code
on(release){
holder_mc.id="188";
holder_mc.type="2 bedroom";
holder_mc.price="$400.000";
holder_mc.availability="yes";
}

I am struggling with transitioning it to a database.

I'd gladly pay you on Thursday
for a hamburger today!