Pass Variable To Flash / Load Row

1

Hi all,
I’ve search for days and nothing has worked so far.

Goal: Load MySQL data in flash depending on url id.
Example: visit.php?pk_listId=185 <= Flash displays row 185

My Results: Flash loads and is blank, but if I change the “SELECT” in visit_bar.php, it works
From: WHERE pk_listId = ‘$pk_listId’
To: WHERE pk_listId = ‘187’

Conclusion: Flash is not getting the variable. ie: $pk_listId

Tested:
myData.load(“visit_bar.php”);
myData.load(“visit_bar?pk_listId=”+random(99), 0);
myData.load(“visit_bar.php?pk_listId=”, 0, “POST”);
myData.load(“visit_bar.php”,"_self",“GET”);
myData.load(“visit_bar.php?pk_listId=$pk_listId”,“GET”);
myData.load(“visit_bar.php”, pk_listId, “GET”);
myData.load(“visit_bar.php?pk_listId=”, $pk_listId);
myData.load(“visit_bar.php?pk_listId=”+random(99), myData, GET);
myData.load(“visit_bar.php?pk_listId=”, 200,“GET”); Works but not dynamic

visit.php
loads swf file with the basic code


<param.....
<embed....

visit_bar.swf
grabs the Id, the flash document has a few fields for display on keyframe one with a stop function


// In the flash document I have 2 Dynamic Text Fields with instance names
// pk_listId_txt
// listTitle_txt
 
// ActionScript
myData = new LoadVars();
/* THIS MUST BE WRONG */
myData.load("visit_bar.php?pk_listId=", 0, "POST"); 
myData.ref = this
myData.onLoad = function(success){
	 if(success){
	 this.ref["pk_listId_txt"].text = this["pk_listId"]
	 this.ref["listTitle_txt"].text = this["listTitle"]
	}
else trace("Error loading data")
}
stop()

visit_bar.php
Connect to MySQL / Query Id / Format Result for flash

 $pk_listId = $_GET["pk_listId"];
 
$MySqlConn = ....
mysql_select_db....
 
	$Query = "SELECT * FROM listing WHERE pk_listId = '$pk_listId' ";
	$Result = mysql_query($Query);
	while ($Row = mysql_fetch_array($Result))
	{
		Print "pk_listId=$Row[pk_listId]&listTitle=$Row[listTitle]";
	}