Dynamic news box

[favaboy]

Hi,
the idea is to do a flash box where the user can scroll through dynamic news, directly picked up from database via PHP code.
Does anyone out there know how to do it? Please, help me or my chief will cook me in a microwave oven!
Resuming: a box that contains dynamic news from a database, these news are extracted with mighty PHP code.
Bye fellas!
Favaboy

[unicycle]

Last week there was a simular question in this forum, then I came up with this:

Layer1 (actions):

frame1:
Load Variables ("http://www.etc.com/"data.php?anticache="& Random (9999), "0"
// make sure you load them into the right level,
// in this case 0.
echo("newsheader1=my boss is not good in his head");
echo("newsheader2=nothing happened");
echo("total=2");
?>
frame2:
Set Variable: "total" = "x"

frame3:
// empty

frame4:
If ((total) ne "x")
Set Variable "count" = "0"
Play
Else
Go to and Play (3)
End if

frame5 till 66 or whatever you make a loop.
in Layer2 you can have a textbox called newstext.
actions:
Set Variable "count" = (count)+ 1
Set Variable "newstext" = "newsheader"& count

frame 66
Go to and Play (5)


I hope you got a clue what I´m doing, if not I can send you a .fla
Further I have not any experience with my SQL athough I´ve seen enough scripts that uses it to know that this will work.
I you cant work it out I can send a sample.