# Consistant Loading to Flash

**URL:** <https://forum.kirupa.com/t/consistant-loading-to-flash/253666>\
**Category:** flash\
**Created:** [March 4, 2008, 12:12am UTC](https://forum.kirupa.com/t/consistant-loading-to-flash/253666 "2008-03-04T00:12:07Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![netfrugal](https://avatars.discourse-cdn.com/v4/letter/n/ecc23a/32.png) [@netfrugal](https://forum.kirupa.com/u/netfrugal)\
**Post date:** [March 4, 2008, 12:12am UTC](https://forum.kirupa.com/t/consistant-loading-to-flash/253666/1 "2008-03-04T00:12:07Z")

</div>

This may be a weird question to ask. Below I have a simple php/mysql query which pulls some simple data.

I’ve figured out how to display it all in Flash. yay for me!

Now here’s what I’m not sure about. If someone updates the database, adding a few new rows in the table, can Flash refresh on it’s own so the new records show in the flash movie?

```php
mysql_pconnect ("Host name", "User Name", "Password");

mysql_select_db ("Datebase Name");
// commentbook is the name of the table. If you have a different table name, use that
$qResult = mysql_query ("SELECT * FROM commentbook ORDER BY id DESC");

$nRows = mysql_num_rows($qResult);
$rString ="&Totalnumber_of_entries=".$nRows;

for ($i=0; $i< $nRows; $i++){
    $row = mysql_fetch_array($qResult);
    $rString .="&ID".$i."=".$row['ID']."&visitor".$i."=".$row['visitor']."&time".$i."=".$row['time']."&comment".$i."=".$row['comment'];
}
echo $rString."&";

```

Or does flash have more than one way to reload all the data again?
