FLASH: Question: Loading variable

[Rainer Egle]

Hi all,


I have a question concerning loading variables in flash. I want to 

load an "array" in Flash. Have a table in a database like:


ID   Name

1	John

2	Marc

3	Sam


Now I want to use a button in Flash (consists of a graphic and a 

textfield).


I get the amount of rows in the database table a variable:


php-code:


<?php

$verbindung = @mysql_connect("localhost","","");

$abfrage = "SELECT Name from Profs1 order by 1";

$erg = mysql_db_query("Profs",$abfrage,$verbindung);

$anzahl = mysql_affected_rows($verbindung);

echo "anzprof=$anzahl";

mysql_close($verbindung);

?>


Now is my question should the php-file for the array should be?


If have this one:


<?php

$verbindung = @mysql_connect("localhost","","");

$abfrage = "SELECT Name from Profs1 order by 1";

$erg = mysql_db_query("Profs",$abfrage,$verbindung);

$i=1;

while (list($Name) = mysql_fetch_row($erg))

{

	echo "profs$i=$Name ";

	$i=$i+1;

}

mysql_close($verbindung);

?>


which gives me the result


profs1=John profs2=Marc profs3=Sam


Is this ok, or should there be a , or ; or & or + instead of the 

blanks? or shoud it be like

profs1=John

profs2=Marc

profs3=Sam


Now I want to read the variable in the textfield of the button, but the 

problem is that I want to duplicate the button, and textfield should 

be named something like profs&i, in this case the button should be 

duplicated three times and I want that textfield in first button gets 

John, textfield in second buttons gets Marc ...?


Is this possible in any way? Tips?


Any help is appreciated, but the most important thing to know it 

this problem can be solved or not?


Sorry for my bad explaining, English is not my strength.


Rainer


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

NudeGuru.com is proud to sponsor the Flasher list

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

        IT'S  THE  ART  OF  MONEY,  HONEY!

 Tips and Advice from some of the most popular Flash

 artists + industry power-brokers on how to hold onto

 your rights, negotiate contracts and get full value

 for your work.http://www.nudeguru.com from Franke James

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

To unsubscribe or change your list settings go to

http://www.chinwag.com/flasher or email

helpchinwag [dot] com