Send PHP variable value to AS3

programming
1

[SIZE=2][AS3 Code]
import flash.net.URLLoader;
import flash.net.URLRequest;
import flash.events.Event;

var phpFile:String = “connect.php”;

function loadFile(evt:MouseEvent):void{
var myLoader:URLLoader = new URLLoader();
var myRequest:URLRequest = new URLRequest(phpFile);
myLoader.dataFormat = URLLoaderDataFormat.VARIABLES;
myLoader.load(myRequest);
myLoader.addEventListener(Event.COMPLETE, loadComplete);
}

function loadComplete(evt:Event):void{
testing.text += evt.target.data.return_msg;
}

loadButton.addEventListener(MouseEvent.CLICK, loadFile);

[PHP Code – connect.php]
<?php
$host = ‘localhost’;
$port = ‘5432’;
$user = ‘postgres’;
$db = ‘db_name’;
$pass = ‘test’;

$connectString = ‘host=’ . $host . ’ port=’ . $port . ’ dbname=’ . $db . ’ user=’ . $user . ’ password=’ . $pass;

$link = pg_connect ($connectString);

if (!$link)
{
die('Error: Could not connect: ’ . pg_last_error());
}
else
{
echo “Database Connection: Success!<br>”;

$query = 'SELECT * FROM students;';
$result = pg_query($query);

if (!$result)
{
    echo "Problem with query " . $query . "&lt;br&gt;";
    echo pg_last_error();
    exit();
}
else
{        
      $trows = pg_affected_rows($result);

[/SIZE] echo “return_msg=” . $trows;[SIZE=2]
[/SIZE][SIZE=2] }
}
pg_close($link);
?>
[SIZE=2]
[SIZE=3]
My problem is [SIZE=2]$trows[/SIZE] returns an undefined/null value to [SIZE=2]evt.target.data.return_msg[/SIZE][/SIZE]
[SIZE=3]But when I test another php file, with the following code:

[SIZE=2]<?php
$trows = 123;
echo “return_msg=” . $trows;
?>[/SIZE]

…[SIZE=2]$trows[/SIZE] works just fine.

Help much appreciated. Thanks.[/SIZE]
[/SIZE]
[/SIZE]