# Pass Variable To Flash / Load Row

**URL:** <https://forum.kirupa.com/t/pass-variable-to-flash-load-row/127158>\
**Category:** Uncategorized\
**Created:** [October 31, 2004, 2:17am UTC](https://forum.kirupa.com/t/pass-variable-to-flash-load-row/127158 "2004-10-31T02:17:05Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![zygote](https://avatars.discourse-cdn.com/v4/letter/z/e480ec/32.png) [@zygote](https://forum.kirupa.com/u/zygote)\
**Post date:** [October 31, 2004, 2:17am UTC](https://forum.kirupa.com/t/pass-variable-to-flash-load-row/127158/1 "2004-10-31T02:17:05Z")

</div>

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

```auto

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

```

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

```auto

// 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

```auto
 $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]";
	}

```