OK i got a wierd problem
<?
$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?