Database Connection & Extraction

[spoondevil]

At the moment, I am just trying to extract info from a MySQL database through Flash via a PHP script. The script is:

<?php
include ('include.inc');
mysql_connect($DBhost,$DBuser,$DBpass);
@mysql_select_db("$DBName");
$query = "SELECT value FROM content WHERE field = 'FrontPageNews'";
$result = mysql_query($query);
$value = mysql_result($result,0,"value");
print "&value=$value";
?>

I have a multiline dynamic text box with a variable name of "value" and the following actionscript:

loadVariablesNum("php/read.php", 0, "POST");
stop();

But it is not extracting the info. It connects to the database fine, as I used it from a tutorial on FlashKit. The script works in phpMyAdmin, just not in Flash.

It does, however, work when I use the following PHP script, but it's not extracting the info from a database though:

<?php
include ('include.inc');
mysql_connect($DBhost,$DBuser,$DBpass);
@mysql_select_db("$DBName");
$query = "SELECT value FROM content WHERE field = 'FrontPageNews'";
$result = mysql_query($query);
$value = mysql_result($result,0,"value");
$test_msg = "hello"; 
$test = "&value=$test_msg"; 
print "$test"; 
?>

The page is at http://test.bigworms.com


Any Ideas?

[Caimin]

When you test in Flash, open up the variables window and have a look - do you see anything that's come back from the server?

If you're sure the PHP script is fine, then chances are that there is a character in the returned $value variable that is preventing the display of the text in Flash: ' for example.