Passing Different Variables in Flash

[cheezyfries]

I need help passing different variables to Flash.
I can list everything from the database, with each item having it's own id number
example:

<?
$server = "localhost"; 
$user = ""; 
$pass = ""; 
$db = ""; 

$conn = mysql_connect&#40;$server,$user,$pass&#41;; 
$db = mysql_select_db&#40;$db&#41;; 

$sql="SELECT * FROM members ORDER BY name_l";
$result=mysql_query&#40;$sql,$conn&#41;; 

while &#40;$row = mysql_fetch_array&#40;$result&#41;&#41; &#123;
$member_id = $row&#91;"member_id"&#93;; 
$name_l = $row&#91;"name_l"&#93;;
$name_f = $row&#91;"name_f"&#93;;
echo &#40;"<font face=verdana size=2><A HREF=\"profile.php?id=$member_id\"> $name_l, $name_f</font></A>"&#41;;
echo "

";
&#125; 
?>

Where member_id is, it changes (obviously), but when I click on a link, it automatically takes me to the first name listed in Flash.

I need flash to know to pull the information corresponding with the proper id number.

You can see what i mean here http://cheezyfries.net/test/test.php

The Flash file pulls the information from here

<?
$server = "localhost"; 
$user = ""; 
$pass = ""; 
$db = ""; 

$conn = mysql_connect&#40;$server,$user,$pass&#41;; 
$db = mysql_select_db&#40;$db&#41;; 

$sql="SELECT * FROM amember_members";
$result=mysql_query&#40;$sql,$conn&#41;;

$row = mysql_fetch_array&#40;$result&#41;; 
$member_id = $row&#91;"member_id"&#93;;
$name_l = $row&#91;"name_l"&#93;;
$name_f = $row&#91;"name_f"&#93;;

echo "&name_f=$name_f&name_l=$name_l&member_id=$member_id"


?>

Can anybody help me?

[NTD]

Hi,

Unfortunatly, I am not very well informed when it comes to mySQL or pulling data from a database. The person to look for regarding this kind of development is "Musicman". He can be found in the backend and scripting forum on Flashkit.com. He is also a moderator for the flash-db.com forums. He is quite the guru when it comes to these kind of development questions.

Sorry I couldn't be of more help
Regards
NTD

[cheezyfries]

Hi,

Unfortunatly, I am not very well informed when it comes to mySQL or pulling data from a database. The person to look for regarding this kind of development is "Musicman". He can be found in the backend and scripting forum on Flashkit.com. He is also a moderator for the flash-db.com forums. He is quite the guru when it comes to these kind of development questions.

Sorry I couldn't be of more help
Regards
NTD

Thank you so much. I have been to 6 different forums asking for help, and you are the first person to give me any kind of a reply.
I really appreciate the reply
Thank You again