I need a Flash applet developed that will go to a MySQL DB and collect a couple fields (I will provide the SQL for you) and then scroll all the results to the screen.
There are 5 types of data that you're going to pull from the DB. All types are just names, (eg: John's Pizza Shop, 416-555-1212), once you run out of "type 1" names, the script should just go and get the "type 2" names, and so on until type 5... then just start at the beginning again.
We know a bit of flash, but not enough to do this properly... but we'd like to go in and change the "look and feel" of the design down the road.
We would need all the flash files so that we can change the Flash should we need to make any changes to your layout. Any code should be commented in such a way that we can go in and make basic changes.
Please see attached image.
As well, we need another scrolling marque, in flash, that also basically goes to a DB and scrolls text like on the bottom of CNN... instead of stock quotes, it will be just current events happening in town.