Hi guys!
I've got a problem with integration b/ween FLASH 5, PHP and MYSQL.
I'm running an sql query in my php script, which gets the firstname and lastname of a user from a database (matching some search terms). Then I want to display these search results in my flash movie. The problem is that the number of these results is different everytime so I don't know how many dynamic textfields to put, nor I know how to put all the variables returned into a single textbox. Please help me if you van. Here is my code:
<?php
include ("dbconnect.php");
$progtext="programmer";
$progquery="SELECT firstname,lastname FROM users WHERE programmer='$progtext'";
$progresult=mysql_query($progquery) or
die (mysql_error() );
echo "Content-type: text/x-www-urlformencoded";
while ($row=mysql_fetch_array($progresult,MYSQL_ASSOC))
{
echo "\n";
while (list($key,$value)=each($row))
{
echo "textbox=$value&textbox=$value";
}
}
