Animate Multiple Data Entries

[nEMESIS4]

I'm a new user to using Flash with Databases, but have extensive CGI/PERL knowledge. I've read through this forum for a number of hours and haven't really had success in finding something specific.

I want to animate a sequence of variables that cycle through a database. The flat file database I have setup right now looks like this:

&rot1=100|895|1502|12506|LEADER|1996|2002|89|
&rot2=100|1200|1802|5106|LEADER2|1998|2004|2|
&rot3=100|895|1502|32506|LEADER3|1996|2002|89|

I want the animation to first display the variables for 'rot1'. Once the animation is complete, it will restart and display the information for 'rot2'. I am able to make the animation display 'rot1' if I hard code a line like this:

myArray = rot1.split("|");

Which creates the following variables for 'rot1':

myArray[0], myArray[1], myArray[2], myArray[3], etc

What I need to do is at the end of the animation, somehow change the myArray line to load up the next set of variables for 'rot2'. This would continue down to the end of the database. Anyone have any ideas, and sorry if my terminology is off at all. Thanks in advance for any help from anyone.

[Musicman]

Hi,

myarray = _root['rot'+index].split('|')

will take the line identified by index, so the last frame of the animation would just change index and restart

Musicman

[nEMESIS4]

Musicman,

Thank you very much, that worked like a charm.