In desperate need of help

programming flash
1

Hi! :hair:

First off, I’m a newbie to Flash/Flex/ActionScript/PHP/MySQL and programming in general.
Secondly, I’ve been trying to get the following thing to work for a loong time now…

  1. You have a PHP script that looks like this:
<?php
    require_once("connection.php");
    require_once("validation.php");
   
    ###READ AND OUTPUT FIELDNAMES OF TABLE STATIONS###
    $query = mysql_query('SELECT * FROM stations');
    $return = "<fields>";
    $numberfields = mysql_num_fields($query);

    for ($i=0; $i<$numberfields ; $i++ ) {
       $var = mysql_field_name($query, $i);
       $return .= "<field><fieldname>".$var."</fieldname></field>";
    }
    $return .= "</fields>";
    echo $return;
?>

This basically gets the fieldnames from a table named stations, and generates an XML-response.

  1. You then wan’t to catch this XML-generated output from PHP to a “container” of some sort in AS3.

HOW WOULD YOU DO IT??? Can you please describe a short example of how YOU would achieve this.

Please, I’m in desperate need of guidelines here…I’ve been posting threads related to this problem on several forums for a while now but noone seems to help out…

Please!
Kenw