# Variables in cache

**URL:** <https://forum.kirupa.com/t/variables-in-cache/44135>\
**Category:** Uncategorized\
**Created:** [February 29, 2004, 9:37pm UTC](https://forum.kirupa.com/t/variables-in-cache/44135 "2004-02-29T21:37:08Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jazzman121](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/jazzman121/32/127_2.png) [@jazzman121](https://forum.kirupa.com/u/jazzman121)\
**Post date:** [February 29, 2004, 9:37pm UTC](https://forum.kirupa.com/t/variables-in-cache/44135/1 "2004-02-29T21:37:08Z")

</div>

OK i got a wierd problem

```php

<?
$dbHost= "localhost";
$dbUser= "sarin";
$dbPass="pingpong
$dbName= "sarin-_db";
$table = "calender";
$link = @mysql_connect($dbHost,$dbUser,$dbPass);
if(!$link) {
	print "couldnt connect to db";
	exit;
	}
if(!@mysql_select_db($dbName)) {
	print "couldnt select db";
	exit;
	}
$query = @mysql_query("SELECT journal FROM journal WHERE id='0'");
$jor = @mysql_fetch_array($query);
mysql_close($link);
echo "&jor=$jor[0]";
?>

```

this is my php code and in flash

i have a main swf… that loads in a swf file with this code

[AS]  
if (\_root.page\_content == “journal”) {  
MyCache.loadMovie(“journal.swf? + int(Math.random \* 10)”,1);  
}  
[/AS]

now… when it loads the swf… the swf get the variables from the database using this code

[AS]  
loadVariables(“journal.php”,this);  
[/AS]

and i have a textfield with variable set to **jor** …

which is the variable from the php file which holds data from the database

when i change text in the database it doesnt change in the swf unless i go to internet properties and empty the cache… even when i hit refresh it doesnt update…

how do I make it so each time u load the swf it refreshes data from the database?