Flash + PHP + MySql ... News

[rionbr]

Ok, I've been trying to do this and got stucked on the Flash part of it.

I want to do a FLASH + PHP + MySql News System.

I've build the tables on mysql, the php to read them, and now I need to show the news on a flash movie.
I wanted to do this way: I've created a movie clip, inside this movie clip I have 3 textBoxes. One for the Date, one for a Title, one for the FullNews. I want Flash to read the php file, check how many news are (the first variable is a total variable) and duplicate my news movie clip below as needed.
PS: As done in www.thecrystalmethod.com

Here the output of my .php file

&total=3

&date0=16/10/2005
&newsshort0=Adriano Maiochi
&newslong0=Adriano maiochi foi felizardo da casa feliz do mes de fevereiro deste ano, parabens
&date1=17/10/2005
&newsshort1=Fabricio Lancini
&newslong1=Fa, foi o sortudo do mes de novembro, ganhou uma passagem para miami
&date2=18/10/2005
&newsshort2=Fabio Lancini
&newslong2=Fabio Antonio contemplou uma carta de credito no valor de 100.000 mil reais, sortudo ele, nao?

**I broke the lines just to be readable, the actual file is continous.**

Can anyone, please help me, or send any links for a tutorial on this kind of integration. Couldn't find any support on Flash + php News System.

THANK YOU! :)

[peptobismol]

check macromedia's flash section. it has a good tutorial on it

[Flash Gordon]

search for "Flash Gordon" and web poll. I have all the sources for a mysql to php to flash poll there. The same idea would apply just text and not numbers.

[KoPanda]

you may check with loadVars object from the help menu. it should help.

[quincewyss]

Check out Peak Studios Flash PHP MySQl extension for AS2 and AS3. I don't know the exact link but the have it on their home page at http://peakstudios.com

It takes cae of all these issuse for you. I have been using it for about a month now. The number of errors I get is about one a week. It used to be about 3 errors a day I work with Flash PHP & MYSQL together all the time.