Data from a mysql database

[OMEGA_ReD]

Hello All,

Im building a new flash website with a mysql db connection.

Im just beginning to understand how it works but there are some unclaritys.

I've uploaded an image to show what my idea is. It's easier for me to make a image than typing the whole scenario, images speak a thousand words!

I need to know what the best way is to let my flash site communicate with the database. I found some tutorials but at this point i can get 1 variable in flash true php.

I prefer to use PHP if possible because i'm most familiar with it!

Can someone point me in the right direction or help me?

Many thanks!

[ASWC]

I output all my data coming from the database as dynamic XML written by my PHP. My advice for you would be just that. Make your PHP open the database and select all data you need then print all of it as XML and load it in your Flash website. Example:

PHP Code:

    $structure = "select * from $table_name WHERE `ID`='$ID';";
    $query_result = mysql_query($structure);
    $content = "<content>";    
    
    while($row = mysql_fetch_array($query_result, MYSQL_ASSOC)){
    $content .= "<SLIDESHOW>";
    $content .= "<ID>".$row['ID']."</ID>";
    $content .= "<BACK>".$row['BACK']."</BACK>";
    $content .= "<DTIME>".$row['DTIME']."</DTIME>";
    $content .= "<TTIME>".$row['TTIME']."</TTIME>";
    $content .= "<COMMENTS>".$row['COMMENTS']."</COMMENTS>";
    $content .= "<RANDOM>".$row['RANDOM']."</RANDOM>";
    $content .= "<ESTART>".$row['ESTART']."</ESTART>";
    $content .= "<WIDTH>".$row['WIDTH']."</WIDTH>";
    $content .= "<HEIGHT>".$row['HEIGHT']."</HEIGHT>";
    $content .= "<EFFECTIN>".$row['EFFECTIN']."</EFFECTIN>";
    $content .= "<EFFECTOUT>".$row['EFFECTOUT']."</EFFECTOUT>";
    $content .= "<EXTRA>".$row['EXTRA']."</EXTRA>";
    $content .= "</SLIDESHOW>";
    }    
        $content .= "</content>";

        print($content);//output the xml