Dynamic Text box displays

programming flash
1

Hi all,

I am fairly new to Flash and AS and need to be able achieve something which I would normally do in PHP within about 5 minutes!

I have a mysql database and in a table I can have multiple records which are controlled via a content management system. The table structure is ID, Title and URL (to keep it simple!).

I need to know how to create a flash document that will display all of the Title fields from each record dynamically in a list. The style and positioning of the titles on my movie is irrelevant at this point.

I already have my PHP file which is as follows:

 
// my page is called getdata.php 
 
$sqlquery = "SELECT * FROM mytable";
 $result = mysql_query($sqlquery);
 while ($datarow = mysql_fetch_array($result)) {
  $id = $datarow['id'];
  $title = stripslashes($datarow['title']);
  $link = stripslashes($datarow['link']);
  
  echo "&title=$title";
 }
 mysql_free_result($result);

As you can see (i think this is correct!) that I am retrieveing the data and displying the **title **one by one.

How do I get flash to dynamically display each title. bearing in mind I never know how many records will be fetched.

Thanks in advance.
Kris