I apologize if another thread already covers this, but my eyes are glazing over from reading so many forum posts, blog posts, etc. about this and nothing has quite made sense yet.

What I am creating is something that will show a replay of a horse race that has already taken place in PHP and stored in MySQL. What I would like to do is have the data in PHP (which includes probably almost 100 variables in total, if not more) sent to my flash file to display the race accordingly. I have gotten the flash part to work properly with dummy variables, but now it's time to start sending some real data into it to be used.

Everything just seems to be a bit over my head. I did some reading on AMFPHP but I am not very comfortable with OOP just yet and I haven't been able to find many examples that would be useful. I wouldn't mind trying the ExternalInterface, but I am not familiar with converting PHP variables into Javascript and most examples I have found are far more complex that I need and I'm having a hard time picking out what it is I do need.

Flashvars seem like they would just cause more work than necessary, since everything would be passed as a string and most of the values are going to be numbers. I've also read a couple of things saying that use of as many variables as I would need isn't really appropriate for use with flashvars.

On top of this, I have some multidimensional arrays being used and I'm not sure if that would cause any issues or not. I know Flash was a little picky about them during their initial creation for my testing purposes, so I'm not sure how they'll be sent over. Essentially, I have a loop in PHP that would grab each horse's time for each fraction of the race and store it in a variable like so:

timedist[0][400]=26.7;
timedist[0][800]=54.1;
timedist[1][400]=27.1;
tiemdist[1][800]=53.8;

With 0/1 representing the number of the horse and the 400/800 (and on up to 3200) would represent the distance traveled so far in the race. Flash then takes the time and uses it accordingly for that horse in that segment of the race.

I have also been debating about trying to use a text file for all of the vars, and pass the name of the text file (which would be different for each race) via flashvars, but I have also read that it would still treat the text file values as strings.

I'm just really at a loss right now and don't know where I should try concentrating my efforts. Everything all at once is just too overwhelming and I am relatively new to a lot of this.

Thanks in advance for any help!