php variables not transferring from mysql to flash

atsphpflash

Hi all,

My data from mysql is succesfully showing up in Flash, unless I try to pass it a variable using GET. The php itself is working when I test it, but it's not showing up in Flash.

The following works just fine, and shows up in Flash as desired:

$query = "SELECT content FROM vision WHERE id='1'";

However, when I try this:
$query = "SELECT content FROM vision WHERE id='$id'";

then pass a variable in the URL for id, nothing happens. How can I get it to pick up the variable?

Here's a look at *all the code:

<?
// formulate and execute query
$query = "SELECT content FROM vision WHERE id='$id'";
$result = mysql_query($query) or die("Error in query: " .
mysql_error());

// get row
$row = mysql_fetch_object($result);

// print output as encoded data for Flash actionscript
echo "vision=" . urlencode($row->content);

// close connection
mysql_close($connection);
?>

Thanks in advance for the help....

cgraz

if the variable id is in the url, then $id will only work if you have globals set to on, but by default, it is set to off.

I'd try using $GET['id']

$query = "SELECT content FROM vision WHERE id='" . $_GET["id"] . "'";

Cgraz

atsphpflash

cgraz

Thanks for the info...unfortunately that still didn't do it. Using that method, do I still need globals on? If so, how do I make sure the globals are on? Do you mean define the variable as a global, or is this something needed on the server side?

atsphpflash

cgraz

Actually, to add to my last reply....the php itself is working, as you can see here:

http://www.atstracts.org/php_includes/flash/flash_content_variables.php?id=1

I've got flash pulling data from the db, if I run a query on a specific record:

WHERE id='1'

but, the problem is that Flash is not pulling in the variable. Ideas?

atsphpflash

cgraz

When you have the id variable defined in the url, echo the following and let me know what it prints:

echo "Globals On: " . $id . "<br>";
echo "Globals Off: " . $_GET["id"] . "<br>";

Cgraz

atsphpflash

OK -

It seems to work both ways....you can see it here:
http://www.atstracts.org/php_includes/flash/flash_content_variables.php?id=1

atsphpflash

cgraz

what do you mean it's not working? try

<? 

$query = "SELECT content FROM vision WHERE id='" . $_GET["id"] . "'";
$result = mysql_query($query) or die("Error in query: " . mysql_error()); 

while($row = mysql_fetch_array($result)) {
   echo $row["0"] . "<br>";
}

?>

Let me know the output

Cgraz