Webmaster Forum / Flash / Data Integration / April 2007

Hi I'm trying to make a news viewing function in Flash 8.  The swf calls out a
php script, php script queries the MySQL DB then php sends info to swf file to
display it.  Unfortunately, the articles don't display and I keep getting
"undefined" errors.  I don't have this problem when I tested it on my PC but
after upoading it to my host the problem arose.

I hope someone can help me.  Thanks!

this is the script i used in flash 8 to call out the PHP script:

function getData(ref) {
    sectionContent = new LoadVars();
    sectionContent.ignoreWhite = true;
    sectionContent.onLoad = function(success) {
        wait._visible = false;
        if (success) {
            pressHead.text = this.headline;
            var newsPic = this.picture;
            var picEmbed = '<img src='+'"'+'images/press/'+this.picture+'"'+'
align="left">';
            contentText.html = true;
            contentText.htmlText = picEmbed+this.article;
           
            calcSize();
            gotoAndPlay(56);
        }
    };
    sectionContent.load("jpg/media.php?row="+ref);
}

this is the script i used in php:

<?
$connect = mysql_connect("localhost", "admin", "password");
mysql_select_db("mydb", $connect);
$sql="SELECT * FROM tbl_press_release";
$result=mysql_query($sql);
    $row=mysql_fetch_assoc($result);
    if(isset($_GET[$row])){
    mysql_query("SELECT * FROM tbl_press_release Where
press_release=".$_GET[$row]."");
    }
?>
<?    echo "&headline=" .  $row["headline"] . " &article=".$row['article']."
&picture=" .  $row['image'] .  ?>
    <?
} mysql_free_result($result);
mysql_close($connect);
?>