# Dynamic Text box displays

**URL:** https://forum.kirupa.com/t/dynamic-text-box-displays/198879
**Category:** flash
**Created:** [August 29, 2006, 11:34am UTC](https://forum.kirupa.com/t/dynamic-text-box-displays/198879 "2006-08-29T11:34:54Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![kriscons](https://avatars.discourse-cdn.com/v4/letter/k/b782af/32.png) [@kriscons](https://forum.kirupa.com/u/kriscons)
#### Post date: [August 29, 2006, 11:34am UTC](https://forum.kirupa.com/t/dynamic-text-box-displays/198879/1 "2006-08-29T11:34:54Z")

</div>

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:

```php
 
// 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