[COLOR=black][SIZE=3][FONT=Calibri]Hello,[/FONT][/SIZE][/COLOR]
[COLOR=black][FONT=Calibri][SIZE=3]I need help populating my flash form with data from mySQL via PHP.[/SIZE][/FONT][/COLOR]
[COLOR=black][FONT=Calibri][SIZE=3][/SIZE][/FONT][/COLOR]
[COLOR=black][SIZE=3][FONT=Calibri]I connect to the database okay. I am having a problem populating my flash fields. It’s a flash form with 7 dynamic text fields. I want to connect to the mysql database and bring to the flash form those fields from the database. There are over 100 rows so I want to be able to show one record on the form, then click a next button to show the next record.[/FONT][/SIZE][/COLOR]
[SIZE=3][FONT=Calibri][COLOR=black]The[/COLOR] print “$Facct=$desiredContent[AccountNumber]”; gives me one account number displayed on the browser. But how do I get the “AccountNumber” to display on my dynamic text field variable named “Facct”? [/FONT][/SIZE]
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]
[FONT=Calibri][SIZE=3]Please keep in mind that I will need to do this for several dynamic fields on the form. The table has 100 records that I want to push to the flash form with a control button called “next” to see the next record. Currently when I run my flash swf that reads the PHP file on my server, the form opens blank. Please help.[/SIZE][/FONT]
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]
[COLOR=black][FONT=Calibri][SIZE=3] [/SIZE][/FONT][/COLOR]
[COLOR=black][SIZE=3][FONT=Calibri]In my movie clip I have:[/FONT][/SIZE][/COLOR]
[COLOR=black][FONT=Calibri][SIZE=3] [/SIZE][/FONT][/COLOR]
[COLOR=black][SIZE=3][FONT=Calibri]onClipEvent (load) {[/FONT][/SIZE][/COLOR]
[COLOR=black][FONT=Calibri][SIZE=3]loadVariables("[/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#0000ff]http://www.xyz.org/testdata.php[/COLOR][/SIZE][/FONT][SIZE=3][FONT=Calibri]", this, “GET”);[/FONT][/SIZE][/COLOR]
[COLOR=black][SIZE=3][FONT=Calibri]}[/FONT][/SIZE][/COLOR]
[COLOR=black][FONT=Calibri][SIZE=3] [/SIZE][/FONT][/COLOR]
[COLOR=black][SIZE=3][FONT=Calibri]In my php file on my server I have:[/FONT][/SIZE][/COLOR]
[COLOR=black][FONT=Calibri][SIZE=3] [/SIZE][/FONT][/COLOR]
[FONT=Calibri][SIZE=3]<?php[/SIZE][/FONT]
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]
[FONT=Calibri][SIZE=3]//Make a MySQL Connection[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]$connection = mysql_connect(“localhost”, “xyz”, “pswd”) or die(mysql_error());[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]mysql_select_db(“xyz_database”) or die(mysql_error());[/SIZE][/FONT]
[FONT=Calibri][SIZE=3] echo “Connected to Database<br />”; [/SIZE][/FONT]
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]
[FONT=Calibri][SIZE=3]//$query = ‘SELECT * FROM account’;[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]//$results = mysql_query($query);[/SIZE][/FONT]
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]
[FONT=Calibri][SIZE=3]////test to get accountnumber from the database[/SIZE][/FONT]
[FONT=Calibri][SIZE=3] $query = “SELECT AccoutNumber FROM account”;[/SIZE][/FONT]
[FONT=Calibri][SIZE=3] $result = mysql_query($query) [/SIZE][/FONT]
[FONT=Calibri][SIZE=3] or die("<b>error</b>: failed to execute query <i>$query</i>");[/SIZE][/FONT]
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]
[FONT=Calibri][SIZE=3] $desiredContent = mysql_fetch_array($result, MYSQL_ASSOC);[/SIZE][/FONT]
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]
[FONT=Calibri][SIZE=3] mysql_free_result($result);[/SIZE][/FONT]
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]
[FONT=Calibri][SIZE=3]//facct is the name of my dynamic text field [/SIZE][/FONT]
[FONT=Calibri][SIZE=3] print “$Facct=$desiredContent[AccountNumber]”;[/SIZE][/FONT]
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]
[FONT=Calibri][SIZE=3]//close connection[/SIZE][/FONT]
[FONT=Calibri][SIZE=3] mysql_close($connection);[/SIZE][/FONT]
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]
[FONT=Calibri][SIZE=3]?>[/SIZE][/FONT]
