Search mySQL from Flash

programming
1

i created mysql database and it displays the records in flash without any problems,

i just wanted to know, if there is a way to integrate a search functionality (search mySQL from flash) using php,

here is my php script:

<?PHP

$link = mysql_connect("localhost","myuser","password");
mysql_select_db("my_store");

$query = 'SELECT * FROM products';
$results = mysql_query($query);

echo "<?xml version=\"1.0\"?>
";
echo "<products>
";

while($line = mysql_fetch_assoc($results)) {
    echo "<item>" . $line["product"] . "</item>
";
}

echo "</products>
";

mysql_close($link);

?>

basically i have a simple database with 1 table and few records, and i just want to search them from flash and return results in flash

i did search this forum but i couldnt find anything to solve this (i think little task)

i appreciate if anyone can help me with this?