Re: flash dynamic text display HTML formatting

[bearslife]

Hi, I am new to flash and am so willing to be taught new things about it. I need help with something I am trying to accomplish here... It is a dynamic text area displaying mysql database records from a pHp script.

I use a button , or in my case the the letter 'A' is clicked and that sends the variable to the php script and then sending it back to my dynamic field.

Now, my problem is, I am not getting all my records displayed upon clicking the Letter Button, I only want Five records displayed at a time. with a next previous link also...
to search through the database.



View --- what_letter.php

if($letter=='act')
{
include('mysql/connect.php');
$query="SELECT * FROM linecard WHERE a_lett LIKE 'A' LIMIT 5";
$result=mysql_query($query);
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
$a_lett = mysql_result($result,$i,"a_lett");
$manufact = mysql_result($result,$i,"manufact");
print "&textField=$manufact";
++$i;
}
}


__________________________________________________ _________

I would also like to format this database record , which is only one "manufacturer" name displayed as a (URL)...

__________________________________________________ _________

My Flash code(AS) is like this:

On the Button Instance:
=========================
on (press) {
loadVariables("what_letter.php?letter=act", "_root.text_box", "GET");

}
=========================

The dynamic text area is within a movie clip.

The movie clip is named "text_box"
:confused:
The dynamic text area is named "textField"
__________________________________________________ _________
So, I am not able to display all my records, just one is displayed in the dynamic text area in the flash movie of mine.

And.....

I don't know how to format the displayed record in flash to place a URL around the displayed record name...

Can someone please help me out, thanks a bunch...

[whozie]

while ($i < $num) {
$a_lett = mysql_result($result,$i,"a_lett");
$manufact = mysql_result($result,$i,"manufact");
print "&textField$i=$manufact"; //***********must increment variable name
++$i;
}


and of course name yoru text field instances: textField0, textField1......textField5