[COLOR=black][SIZE=3][FONT=Calibri]I need help with the PHP script that will populate my flash fields.[/FONT][/SIZE][/COLOR]
[COLOR=black][/COLOR]
[COLOR=black][SIZE=3][FONT=Calibri]I connect to the database okay. I am having a problem populating my flash dynamic text 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 in my form. 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 “content=$desiredContent[facct]”; gives me a blank. If I change it to the name on the database print “content=$desiredContent[AccountNumber]”; The account number is printed out which is what I want, but how to get it to show in my flash form and flash will know to attach Account Number to my dynamic field names Facct?[/FONT][/SIZE]
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]
[FONT=Calibri][SIZE=3]I will need to do this for several dynamic fields. The table has 100 records that I want to push to the flash form with a control of next to see the next record. 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 “content=$desiredContent[facct]”;[/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]
Please help.
TheWayWeWere
