HELP! Data integration...

[mynameisnick]

Hello All, hope you can help me a little.

I want to create a flash page what will constantly loop a MYSQL database, displaying text from one of the fields....i need it to loop constantly so that when a new item is added, it shows on screen (when the loop reaches the end)

How hard is this to do? Does anyone know where I can find some starter code or tutorials?
Or does anyone care to explain it to me?

Thanks in advance,
Nick

[RubenFlash]

Use setInterval, like this:



function myFunction(){
//query the database
}

myInterval = setInterval(myFunction, 1000)//calls the function one time every second

[creatify]

There are a few flash/php/mySQL tutorials out there - there is one about 3/4 the way down in his list menu here: http://www.gotoandlearn.com/

I think there is a tutorial here on kirupa too. There are some learning curves if you've never done this, but its not too bad after you set it up and see how it works. I'm a huge fan of amfphp.org - check them out, its a flash->php->mySQL remoting protocal, and its free.