Flash IDE not communicating properly with PHP

programming flash
1

I have a rather strange problem. Well, at least I think it’s strange. I’m making a Flash program that reads a mysql database query in a PHP file.

When I compile and publish my flash movie and put it in my xampp/htdocs folder and then run the movie from Firefox, it works just fine. However, every time I try and run it in the Flash IDE, the PHP script doesn’t get compiled. Instead, the uncompiled code gets read in as the data, and so when I run trace(evt.target.data), it basically shows all the PHP code plus a bunch of other gobeldygook. If I remove out the line [FONT=&quot]loader.dataFormat=URLLoaderDataFormat.VARIABLES;, it then just shows the PHP code as is.

My question is this: what do I have to do to make the IDE run the compiled PHP script instead of just loading in the raw code as is? In case it helps, here’s[/FONT] my PHP code:

    <?php

    $hostname = "localhost";
    $con = mysql_connect($hostname,root,password);
    if (!$con) die('nv=didnotconnect');
    
    mysql_select_db(test, $con) or die('nv=couldnotselectDB');


   $result = mysql_query("SELECT student_number, student_name FROM students", $con) or die('nv=couldnotselectvalues');


$count = 1;

while($row=mysql_fetch_array($result)){
  echo "student_number$count=$row[student_number]&student_name$count=$row[student_name]&"; 
    $count++;
}

echo "count=$count"; 

?>

AS3 code:

    
[FONT=&quot] var loader:URLLoader = new URLLoader();

var urlRequest:URLRequest=new URLRequest("receive.php");

urlRequest.method=URLRequestMethod.GET;

// Read returned values from external source as variables
loader.dataFormat=URLLoaderDataFormat.VARIABLES;

// Listen for completion
loader.addEventListener(Event.COMPLETE, onComplete);
loader.load(urlRequest);

function onComplete(evt:Event):void {

        // Stop listening for completion
        loader.removeEventListener(Event.COMPLETE, onComplete);
&#12288;
        trace(evt.target.data);

        //I used the GUI to add several textfields to the stage
        studentNumber1.text=evt.target.data.student_number1;
        studentNumber2.text=evt.target.data.student_number2;
        studentNumber3.text=evt.target.data.student_number3;
        studentName1.text=evt.target.data.student_name1;
        studentName2.text=evt.target.data.student_name2;
        studentName3.text=evt.target.data.student_name3;

        // Update array with new values from external source


        // Send notification upon completion of array

}[/FONT]

Anyway, any help would be greatly appreciated.

Stardog.
Toride, Japan.