mySQL and Flash integration

[tom]

Hey

Does anyone know how to integrate Flash and mySQL databases (and PHP I guess)  so you can extract page content out of a table (providing dynamic content) I can write PHP, but it's the actionscripting that I'm not so sure on.

Any help on this would be great,

Tom  

[Musicman]

in the simplest case, your PHP should send
textboxname=
followed by the content, where textboxname matches the name of a dynamic text box. The actionscript would just use
loadvariables('script.php', _root)
to get the data.

Musicman

[de koster]

and what if it's necessary to repeat some regions a few times? Imagine Mysql returns a few lines with for each line a title, some text, date and author... And I want to have the title in bold, then a blank line, then the text in small font, then a blank line, then the date and author at the right side and then a line for seperating the next info... something that would look like this :

title1

this is the text from my first article, bla bla bla bla...

26/02/02 J. BROWN

________________________________________________

title2

this is the text from my second article, bla bla bla bla...

26/02/02 M. SMITH

________________________________________________


Would you still use one dynamic text box???

[flashswami]

No, in this case you have as many textboxes as there are sections e.g.

title1

this is the text from my first article, bla bla bla bla...

26/02/02

J. BROWN

Are all in 4 seperate textboxes, positioned in the manner you want on the stage, replete with lines, artwork etc. The trick is to put all these items inside one movieclip, now what you can do is duplicate this clip depending on the amount of records you retrieve from your db.