Webmaster Forum / Flash / Data Integration / February 2005

I have a movie sample that I downloaded because I dupoicated the same movie how
I wanted it to look.  However when I was done it didn't work.  To check if it
was me, I downloaded the exact sample and changed the database info, then
uploaded the page and it still didn't work.  I made a move that will get some
variables from a php page, which tapped into a database for the info, and
display the data in a text field.  The data doesn't display.  Here is the flash
page:
isle10.com/unit.html.

Here is the same php page:
isle10.com/test.php.

Can anyone help me?

Code for php:
<?php
mysql_connect("dbname","dbuname","pwd");
mysql_select_db("whatdb");
$qr = mysql_query("SELECT * FROM unit");
$nrows = mysql_num_rows($qr);
for ($i=0; $i < $nrows; $i++) {
  $row = mysql_fetch_array($qr);
  echo $row['lastName'].", ".$row['firstName']."<br>";
  echo " ".$row['phone']." ".$row['email']."<Br>";
  echo " ".$row['picFile'].":
".$row['caption']."<Br><Br>";
}
?>

Now, here is the tutorial site which is here on macromedia:

http://www.macromedia.com/devnet/mx/flash/articles/flashmx_php.html

action script code:

function showjpg(paramString) {
    // get the individual parameters:
    // params[0] = picture file name
    // params[1] = caption
    var params = paramString.split("#");
    picHolder.loadMovie(params[0]);
    caption.text = unescape(params[1]);
}
function showContent() {
    var i;  
    content.htmlText = "";
    for (i=0; i < this.n; i++) {
        if (this["picFile"+i] != "") {
            content.htmlText += "<b>" + this["firstName"+i] + " " + this["lastName"+i]
+ "</b>" + "<a href='asfunction:showjpg," + this["picFile"+i] + "#" +
escape(this["caption"+i]) + "'>&nbsp;&nbsp;(<font
color='#0000cc'>pic</font>)</a><br>";
        } else {
            content.htmlText += "<b>" + this["firstName"+i] + " " + this["lastName"+i]
+ "</b><br>";
        }
        content.htmlText += "&nbsp;&nbsp;" + this["phone"+i] + "<br>";
        content.htmlText += "&nbsp;&nbsp;<a href='mailto:" + this["email"+i] + "'>"
+ this["email"+i] + "</a><br><br>";
    }
}

// Create new load vars object c for data transfer
var c = new LoadVars();
c.onLoad = showContent;

// define content and actions for each tab
for (var i=65; i<=67; i++) {
    this["tab"+chr(i)].letter.text = chr(i);
    // when this tab is clicked
    this["tab"+chr(i)].onRelease = function() {
        // can't use chr(i) here -- must use mc name
        c.thisLetter = this._name.substr(3,1);
        bigLetter.text = c.thisLetter;
        content.htmlText = "Loading data for " + c.thisLetter;
        // scope of this function is main timeline so can refer to c directly
        c.sendAndLoad("power.php",c,"POST");
    }
}

stop();

The php page works just fine without flash, but the flash will not display it.
Can anyone point me in the right direction.  I'm using Flash MX.  Thanks.

Josh.