# Search mySQL from Flash

**URL:** <https://forum.kirupa.com/t/search-mysql-from-flash/253583>\
**Category:** programming\
**Created:** [March 3, 2008, 8:38am UTC](https://forum.kirupa.com/t/search-mysql-from-flash/253583 "2008-03-03T08:38:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![biztaty](https://avatars.discourse-cdn.com/v4/letter/b/ecccb3/32.png) [@biztaty](https://forum.kirupa.com/u/biztaty)\
**Post date:** [March 3, 2008, 8:38am UTC](https://forum.kirupa.com/t/search-mysql-from-flash/253583/1 "2008-03-03T08:38:35Z")

</div>

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
<?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?