I am trying to move between Flash and PHP.
Without knowing flash, here is the situation from a PHP perspective:
The data must be called from PHP.
We need to pass ALL data in each row, from the PHP form to Flash.
Flash reads all data by a URL and there is apparently no way for Flash to connect directly to mySQL, it must have PHP, ASP etc to pass the data.
How can we create a scenario in PHP that allows us to specify each row in the mySQL table, basically allowing us to advance one record at a time, pass the values to Flash, then go back to PHP and get the next record.
* Please keep in mind that we can only advance the record one at a time! We cannot have PHP throw all the values into an array OR have it echo multiple lines. *
It must do as follows:
- Flash goes to PHP
- PHP connects to DB and pulls the first record
- PHP sends the data (via a URL) to Flash and Flash processes it.
- Flash loads the information and then goes back to PHP for the second record.
- PHP passes the second record to Flash, etc.
The PHP page needs to only process one value at a time, but the script has to be able to identify each row in the database.
I am sorry if this is a bit confusing.... if no one can get it, I'll try to rephrase it.
Thanks!