Flash >< PHP / Mysql

[m_ike842]

Im making this system where a user clicks on a link and it sends the ID of that object in the database ie...

index.php?view=24

and then what im doing is on that "index.php" "page" im having the database look for that ID and getting the FILENAME from the database,,

Function LOADFLV()
{
$theview = $_GET["view"];
$result = mysql_query("SELECT * FROM content WHERE ID = '$theview'");
$r = mysql_fetch_array($result);
$thefilename = $r["FILE"];
}

Now below this script i have a flash FLV player, I would like to load the video from that > "$thefilename" ..

_root.loadVariablesNum("index.php",'GET');

theplayer.load("contentsss/" + thefilename);

contentsss being the folder of the stored flv's ..
I cant get it to work, any ideas?

[phparion]

print the path of flv movie before loading it to make sure you got it correct.

Second thing you can check is your loading movie clip instance name. I am assuming that "theplayer" is an empty movie which has the instance name as "theplayer" in which you load the flv movie. so you need to check if you have assigned the instance name to it.

[m_ike842]

is there a way i can get the variables into flash with out using the "&x=320498&y=weruwer"? I dont want the variables to be seen

[henry0]

Don't know about flash
but you might try using a SESSION
if security is a concern then a SESSION could be (almost) well protected.