# Help drastically needed passing variables

**URL:** <https://forum.kirupa.com/t/help-drastically-needed-passing-variables/161749>\
**Category:** flash\
**Created:** [September 6, 2005, 8:31pm UTC](https://forum.kirupa.com/t/help-drastically-needed-passing-variables/161749 "2005-09-06T20:31:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cheezyfries](https://avatars.discourse-cdn.com/v4/letter/c/97f17d/32.png) [@cheezyfries](https://forum.kirupa.com/u/cheezyfries)\
**Post date:** [September 6, 2005, 8:31pm UTC](https://forum.kirupa.com/t/help-drastically-needed-passing-variables/161749/1 "2005-09-06T20:31:27Z")

</div>

[http://www.cheezyfies.net/test/test.php](http://www.cheezyfies.net/test/test.php) ok.  
I have a PHP script that will automatically pull names out of a MySQL database and display them, here

```php

<?
$server = "localhost"; 
$user = ""; 
$pass = ""; 
$db = ""; 
 
$conn = mysql_connect($server,$user,$pass); 
$db = mysql_select_db($db); 
 
$sql="SELECT * FROM amember_members ORDER BY name_l";
$result=mysql_query($sql,$conn); 
 
while ($row = mysql_fetch_array($result)) {
$member_id = $row["member_id"]; 
$name_l = $row["name_l"];
$name_f = $row["name_f"];
echo ("<font face=verdana size=2><A HREF=\"test10.php?id=$member_id\"> $name_l, $name_f</font></A> - [$member_id]");
echo "<br><br>";
} 
?>

```

There will constantly be new names being added, so I cannot hard code an id number into the .swf

The names then become a link with their own corresponding member\_id being the variable to pass.  
When you click on a person’s name, it will display their information in the .swf.

When you click on a person’s name, the only information that I am getting, is the first person listed on the list. It’s like Flash dosen’t recognize the member\_id being passed.

Here is the page with the .swf embed on it that should display the information about each individual person

```auto

<?
$server = "localhost"; 
$user = ""; 
$pass = ""; 
$db = ""; 
 
$conn = mysql_connect($server,$user,$pass); 
$db = mysql_select_db($db); 
 
$sql="SELECT * FROM amember_members WHERE member_id=$id";
$result=mysql_query($sql,$conn);
 
$row = mysql_fetch_array($result); 
$member_id = $row["member_id"];
 
echo "$member_id";
?> <br> 
<!-- URL's used in the movie-->
<!-- text used in the movie-->
<!--SEQUENCE LOADING-->
<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="[http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0](http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0)"
WIDTH="800" HEIGHT="600" id="test" ALIGN="">
<PARAM NAME=movie VALUE="test.swf?id=<? echo member_d?>"> 
<PARAM NAME=quality VALUE=high> 
<PARAM NAME=bgcolor VALUE=#000000> 
<EMBED src="test.swf?id=<? echo member_d?>" quality=high bgcolor=#000000 WIDTH="800" HEIGHT="600" NAME="test" ALIGN=""
TYPE="application/x-shockwave-flash" PLUGINSPAGE="<A href="http://www.macromedia.com/go/getflashplayer"></EMBED">http://www.macromedia.com/go/getflashplayer"></EMBED>
</OBJECT>

```

The AS I have in the .swf is

```auto
loadVariables("test1.php","")

```

You can see what I mean by going here  
[http://www.cheezyfries.net/test/test.php](http://www.cheezyfries.net/test/test.php)

Please, if anybody can help me. Other forums and people have tried, and either I’m not understanding them, or they are not understanding what I need to happen.  
Feel free to contact me directly thru email