# Flash mx to mysql database

**URL:** <https://forum.kirupa.com/t/flash-mx-to-mysql-database/72673>\
**Category:** Uncategorized\
**Created:** [December 8, 2004, 6:11am UTC](https://forum.kirupa.com/t/flash-mx-to-mysql-database/72673 "2004-12-08T06:11:30Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![olm75](https://avatars.discourse-cdn.com/v4/letter/o/8c91f0/32.png) [@olm75](https://forum.kirupa.com/u/olm75)\
**Post date:** [December 8, 2004, 6:11am UTC](https://forum.kirupa.com/t/flash-mx-to-mysql-database/72673/1 "2004-12-08T06:11:30Z")

</div>

[font=verdana, arial, helvetica][size=2]ok can u show me how to search the mysql database i would greatly appreciate it cuz im pulling my hair out over here…im using flash mx and PHP…

here’ the the query but i dont know how to put it in a script:

$query\_searchRS = sprintf(“SELECT city, `state`, `area code`, `venue type`, `music type`, `age group`, venues.city FROM venues WHERE `venue name` = ‘%s’ AND venues.`state` AND venues.`area code` AND venues.email AND venues.website AND venues.`venue type` AND venues.`music type` AND venues.`age group` ORDER BY `venue name` ASC”, $colname\_searchRS);

can u show me how to wright the rest of the script plz…(and please explain like i am very slow lol…)…  
here is the .fla…  
and there is an example on my site [nightspotz.com](http://nightspotz.com) and go to the search link[/size][/font]