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
<?
$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
<?
$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
loadVariables("test1.php","")
You can see what I mean by going here
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